Skip to main content
S
ShulyM
October 25, 2022
Solved

client billings report

  • October 25, 2022
  • 1 reply
  • 0 views

Hello-

we use Enterprise QB and our creative team would need a weekly report of the client billings, paid and unpaid dates, coming from their team alone (not media).

We separate the clients by jobs and GL account numbers:

GL account 4005 is Creative Fees

GL account 4025 is Media Fees

for some reason I'm unable to find a way to separate these in the report as I'd like to not share with the creative team the media billings.

Any input/advise would be greatly appreciated.

thanks!

Best answer by Mark_R

Welcome back, @ShulyM.

 

Adding a Paid Date column on the Transaction Detail by Account report is currently unavailable. As a workaround, you can consider running a different report such as Transaction List by Customer to add a Paid Date column. Here's how:

 

  1. Go to the Reports menu, then select Customers and Receivables and choose Transaction List by Customer.
  2. Click Customize Report.
  3. In the Display tab, go to the Columns section and search for Paid Date. Then, put a checkmark on it.
  4. Go to the Filters tab, search for Transactions Type and choose Invoice from the drop-down.
  5. Click OK once done.

 

If you don't want to run another report, you'll need to manually open each invoice to see the date when it was paid.

 

Also, I'd suggest submitting feedback to our product engineers. They may look into this suggestion and consider adding the Paid Date column in the Transaction Detail by Account report. To submit feedback, you can go to the Help menu and select Send Feedback Online. Then, choose Product Suggestions and enter your feedback.

 

You may also want to memorize reports in QuickBooks. This will help run the same settings of the customized report.

 

Our Community forum is always open to help you again if you need further assistance on this concern. Have a good one.

1 reply

G
GlinetteC
October 25, 2022

I've got a way of what report you can pull up, ShulyM.

 

You can run the Transaction Detail by Account report and add the Paid column. On the Filters tab, select the transactions/account on the drop-down list depending on the data needed. Let me show you how:

 

  1. Go to Reports > Account and Taxes, then select Transaction Detail by Account.
  2. Click Customize Report.
  3. On the Display tab, search Paid column, then click OK.
  4. On the Filters, select the specific account/ transaction needed and click OK.

 

In addition, I've added these links that'll help you personalize and memorize your financial reports. This way, you can easily access them in the future:

 

Keep me posted if you need more help managing reports in QuickBooks. I'll be around to help.

S
ShulyMAuthor
October 25, 2022

this looks almost all of what I need...only column missing is the date client paid the invoice.

Is that something you are able to provide the instructions for?

many thanks!

M
Mark_RAnswer
October 25, 2022

Welcome back, @ShulyM.

 

Adding a Paid Date column on the Transaction Detail by Account report is currently unavailable. As a workaround, you can consider running a different report such as Transaction List by Customer to add a Paid Date column. Here's how:

 

  1. Go to the Reports menu, then select Customers and Receivables and choose Transaction List by Customer.
  2. Click Customize Report.
  3. In the Display tab, go to the Columns section and search for Paid Date. Then, put a checkmark on it.
  4. Go to the Filters tab, search for Transactions Type and choose Invoice from the drop-down.
  5. Click OK once done.

 

If you don't want to run another report, you'll need to manually open each invoice to see the date when it was paid.

 

Also, I'd suggest submitting feedback to our product engineers. They may look into this suggestion and consider adding the Paid Date column in the Transaction Detail by Account report. To submit feedback, you can go to the Help menu and select Send Feedback Online. Then, choose Product Suggestions and enter your feedback.

 

You may also want to memorize reports in QuickBooks. This will help run the same settings of the customized report.

 

Our Community forum is always open to help you again if you need further assistance on this concern. Have a good one.

Terms & ConditionsAccessibility statement