Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
E
eic90
New Member
July 7, 2026
Question

Report including bills on invoice date instead of bill payment date

  • July 7, 2026
  • 1 reply
  • 15 views

Hi, I am having a problem with the Financial activities by Tag Group report, I am sure it’s likely my misunderstanding than an issue with QB! I am running it for this quarter split by month. However, under April for Phone Costs (to make up an example), it’s missing a transaction that was billed in March but paid in April. Is this because it’s under Accrual? When I change the report to Cash basis, then it includes the missing transaction but also Unapplied Cash Bill Expenditures from the Credit Card account so neither Cash nor Accrual basis is matching the total figure I have in my own spreadsheet. I understand there’s a bit of an offset with the Credit Card account because paying it off each month doesn’t exactly match the calendar month but the month in the statement but is there any way to make sure the bill payments are included based on when they were actually paid, not the date on the bill itself?

Also is it possible to run a similar report of Financial activities by Tag Group split by month but just for one account? I have run a report from the Chart of accounts but it’s not giving me the same options to do it by account category and month.

Hoping I’ve explained clearly enough and thanks in advance

E

1 reply

S
ShangYQuickBooks Team
QuickBooks Team
July 7, 2026

To get the exact report you need, keep the report on a Cash basis to ensure you get the actual payment dates right. Then, customise the report to eliminate credit card noise and focus on the specific account you wish to view.

 

Let's start by setting up the Monthly Tag Report by Account:

 

  1. Pull up the Financial Activities by Tag Group report (also known as Profit and Loss by Tag Group)
  2. Set your desired Report period.
  3. In the Display columns by drop-down, choose Months and select Cash for the Accounting method.
  4. Run the report.

 

As for the Unapplied Cash Bill Expenditures, this usually happen on Cash basis reports because bill payment is sitting in a clearing state before hitting an expense. To isolate only the actual cleared data for a specific account and remove any unapplied accounting noise, follow these steps:

 

  1. Click the Customise button at the top right next to Save As. Then, click the Filter drop-down to expand it.
  2. Choose Account Type >equals> select only the specific bank/credit card you want to run the report for.
  3. Select Apply changes. 

 

If you want to see specific expense categories (like Phone Costs) associated with that account, you can also use the Distribution Account filter.

 

You may also save the customisation of this report for future use.


Let us know if you have further questions or concerns

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement