A/R Report

Yes.  Run an A/R Aging Detail report and then Add the Debit and Credit, and perhaps Amount columns.

Big Red,  Thank you.  when I do that, it does the original GROSS amount, not what is remaining. 

i.e 

client has a cr of 10K

Inv for 5K, PD from the 10K

Inv for 2K, PD from the 10K

Bal should be 3K

On the Current QB A/R rpt, it shows a credit of 3,000.00 (Which is correct)

HOWEVER, when I add the Dr and Cr columns... it will show the 10,000 as a credit NOT the remaining bal of 3,000.00 cr.

Hello, @K-DOI.

QuickBooks Desktop uses double entry accounting, there should be at least 2 accounts affected for every transaction. This is why your debit and credit columns are showing the 10,000. 

However, I also suggest reaching an accountant or a tax advisor to get an advise about these journal entries. 

Check the following article to check all the reports that we have and on how to customize them  based on the needs of the business: 

Customize company and financial reports.

Let me know if there is anything I can assist you with by leaving a comment below.​ I'm always glad to help in any way I can.

Mary Jo, thank you for your response.  I believe you do not understand the question.  I fully understand why the 10K is showing in QB as a CREDIT, it is NOT and should not be showing as a DEBIT on the clients end.  Accounting in itself IS double entry, i.e. for every debit you need a credit.  This is not a JE. Possibly, you erroneously replied to my question, where your answer is for a totally different question.

Thank you for the clarification, @K-DOI.

Let me share additional insights about running the A/R Aging Detail report in QuickBooks Desktop.

Your report is correct. The A/R Aging Detail report's debits and credits will display the total amount of the transaction when it was created. To check for the current balance, you can look for it under the Open Balance column.

At this time, you can click on the credit memo to open it. Once done, you can see the original amount from the Amount column and the current balance beside the Remaining Credit section.

If you need additional help with customizing your reports, feel free to read the details from this link: Customize reports in QuickBooks Desktop.

Once done, you may also read the topics from our help articles in case you need related resources while working with QuickBooks in the future.

Leave a comment below if you have any other questions. I'm always here to help. Keep safe always!

Angelyn, thank you for your response.

I am looking for a report which gives the GROSS of OPEN invoices and the GROSS of OPEN Credits. Not the NET which the A/R Open Invoices shows.

I've attaching part of the rpt I created in Excel  You will notice on the bottom, the DEBIT column (Actual Open Invoices) is $1,374,468.98.  The QB report, shows what the NET is $567,707.18, which includes the credits on account.

Thanks for the assistance.

Thank you for reaching out to us again and providing more information, K-DOI. However, the customize option can filter gross from the net, but it will not apply to invoices or bills, only payroll. For more information, I recommend reviewing the article about customizing reports, as my colleague mentioned above. Again, you are welcomed to comment below if you have any more questions. Take care, and enjoy your day.

I guess, that is the simple way of saying, "NO, you can not create that type of report in QuickBooks".  I have been doing it for several decades in Excel, just thought QB might have upgraded their reports.  

Thanks for visiting us again and sharing your insights about the reports in QuickBooks, @K-DOI,

While the option to generate the exact reporting format you need in QuickBooks is currently unavailable, I have a workaround that might help you. This is the closest report I can find to display the information similar to the Excel report you have shown us.

We will use a Custom Transaction Detail Report for this. Follow the steps below to get this type of report:

1. Go to the Reports menu and choose Custom Reports.
2. Select Transaction Detail from the list.
   
3. On the report, we need several filter modification to match your Excel file. For this, click on Customize Report.
4. In the Display tab, update the Report Date Range and Report Basis.
5. Under Columns, remove the unnecessary columns on the report by removing the check mark. See this:
   
6. Add a check mark for columns you want to add.
7. ​​​​​​Next, go to the Filters tab, then click on Account. Use All accounts receivable from the drop-down beside it and hit the No radio button.
   
8. Now, scroll down the filters and look for Transaction Type.
9. Select Multiple Transaction Type, then pick the A/R transactions like invoices, credit memos and journal entries.
   
   
10. Scroll further and look for Paid Status and select Open.
    
11. On the same screen look for the Posting Status filter and choose Either.
    
12. Once done, click OK and this is how it will look like:
    
13. (Optional) You can use the Memorize button at the top to save the customizations of the report, so you don't need to do it every time. You can access it again under Reports then Memorized Reports.
    
    

I'm also adding some related articles to help you learn more about the reports in QuickBooks:

• Understand reports 
• Customize reports
• Create, access and modify memorized reports

Let me know if need additional assistance with this or have other questions with QuickBooks. I'll be right here to help. Have a lovely day!

Jen_D, thank you for your response.

Glancing at the report, it looks like it will work.  I will have to give it a try next week.  I will let you know either way.

Again, thank you for the response!!  Have a great weekend!!

K

Jen_D,

I haven't forgotten you.  I have been swamped.  I will keep you abreast ,as soon as I work on it!

º¿º

Jen_D,

We 99% there.  I was able to recreate all the steps you gave for the report.  (BTW, You are an EXCELLANT TRAINER!!!) All we need, is to have each Customer, with their separate totals, as you can see from my Excel rpt. (I have changed our customer names, to maintain confidentiality)

 I have attached a partial excel rpt so you can see the customers.

Hi there, @K-DOI.

I appreciate taking the steps provided by my colleague Jen_D. So, let me step in and assist you to pull up your customer's separate total report.

You can customize the report, change the Total by field to customer to show each customer's total in the statement. You can follow these steps on how:

1. In the report, click the Customize Report button.
2. Select the Total by drop-down arrow.
3. Choose the Customer option.
4. Hit the OK button to refresh the report and show the customer's total.

You can use these screenshots as your reference.

I've also added an article that helps you set up a scheduled report that allows you to send reports on a regular and recurring scheduled time: Set up and modify Scheduled Reports.

If you have follow up questions, feel free to leave a message in the comment section. I'm always around here in the Community to help. Take care, and have a good day.

Rejeil_O,

Thank you for your response! I believe we have it at 100%!  It appears your suggestion was what was missing.

This is a report I run weekly, so, when I run it next week, I will be more certain.

With Jen_D doing the hardest part, and you finishing it up... it looks like what I need!!  I have memorized it and will put it to work next week.  I will let you both know!! (If it all goes according to plan, I will close this thread.)

Thank you both so very much!!  Have a GREAT weekend.

You’re always welcome, @K-DOI.

I’m glad to know that the steps provided by my colleagues above help you get the report you need.

In case you have any other concerns or questions about managing your QuickBooks Desktop (QBDT) software, you’re always welcome to leave a reply in this thread. We’re always ready to help you out.

Take care and see you around!

Good Morn'n!

Sorry to inform you, it does not work. :(   I have attached the TOTALS pages of:

(3) Open Invoices Report (QuickBooks Report)

(1) MY Excel Report

(2) Custom Transaction Detail Report (QuickBooks Report)

And I have attached some of the detail from each report:

(1) My Excel Rpt   (Which corresponds with the QB "Open Invoices"   :) )

(2) Custom Transaction Detail Report (QuickBooks Report)

(3) Open Invoices Report (QuickBooks Report)

It appears the "Custom Transaction Detail Report" is taking the GROSS (Original) amounts of invoices/credits, rather than the NET amounts (after they have been applied).  I drew arrows to show what is on the "Open Invoices Report" vs what is on the  "Custom Transaction Detail Report" so you can see what I mean.

I hope this helps to explain what I need vs what is happening.

Please feel free to contact me with any questions.

Thank you so much!

Hello @K-DOI,

I appreciate you for adding more details here in the Community. Allow me to chime in and help you with the report in QuickBooks Desktop.

Since you need the net amount, you can customize the existing report and add a column for Open Balance. Please start making the changes by going to the Display tab.

For the detailed steps, here's how:

1. Open the memorized Custom Transaction Detail report.
2. Click the Customize Report option.
3. Below Columns, add Open Balance. 
4. You can remove the Amount column if you don't need it.
5. Make the necessary changes, then hit OK.

For additional reference, you can use the following article to learn more about how you configure reports further in QuickBooks: Customize reports in QuickBooks Desktop.

Keep us posted if you need anything else regarding the report. Have a great day!

Thanks for your reply.  Still not what I am looking for.  YES, the "Open Balance" is correct.  However, when you subtract the Debits from the Credits, it should equal the OPEN BALANCE amount, it does not.  Any suggestions.

In other words, the OPEN BALANCE should be the total of the Debits and Credits. i.e. the Debits and Credits is just breaking it down to how much of the OPEN BALANCE are Debits.... and how much are Credits.

Example:

Open Bal             Debits               Credits

100,758.14       116,552.17        $15,794.03

Debits                $116,552.17

Credits                <15,794.03>

Open Balance $100,758.14  

I did take the Amount and Balance off of the report.

Thank you.

Thanks for coming back and updating us about this, @K-DOI,

We already have tried ll possible customization to get the data you need. However, if this isn't the information you're looking for, our last resort is to export the data outside QuickBooks. I know that this is something you're currently doing, so we ask for your patience while the exact report you want is currently unavailable.

We understand that working in a spreadsheet can be tedious process. I'll make sure that this suggestion reaches our developers for review. You can also log your product suggestions inside your company file. Just go to the Help Menu and select Send Feedback Online.

If there's anything more I can help you, let me know by adding another comment below.