cancel
Showing results for 
Search instead for 
Did you mean: 
rtroofing1
Level 1

My customer's paid invoice is showing as an open balance A/R Aging Report

I'm currently running Quickbooks Pro 2016 - My customer's paid invoice is showing as an open balance A/R Aging Report. How can I edit the discrepancy to show $0.00 on my open balance on the AR Aging Report?

 

The customer's invoice shows as $0.00, but the Open Balance on the A/R Aging Report shows $13,050.00...I'm hoping I can get some assistance on how to just edit the open balance.

Thanks!

Solved
Best answer March 15, 2018

Best Answers
MorganB
Content Leader

My customer's paid invoice is showing as an open balance A/R Aging Report

Hi rtroofing1,

 

Welcome to the Community. I'm happy to help point you in the right direction to keep the paid invoices from showing as open balances.

 

This link will direct you to a write-up that explains why this is occurring with your customer's paid invoice, as well as options to get it resolved: https://community.intuit.com/articles/1502153-a-paid-bill-or-invoice-shows-on-report-or-window-of-op....

 

You'll be back to business in no time. Keep up the great work and please let me know if you have any other questions.

View solution in original post

6 Comments 6
MorganB
Content Leader

My customer's paid invoice is showing as an open balance A/R Aging Report

Hi rtroofing1,

 

Welcome to the Community. I'm happy to help point you in the right direction to keep the paid invoices from showing as open balances.

 

This link will direct you to a write-up that explains why this is occurring with your customer's paid invoice, as well as options to get it resolved: https://community.intuit.com/articles/1502153-a-paid-bill-or-invoice-shows-on-report-or-window-of-op....

 

You'll be back to business in no time. Keep up the great work and please let me know if you have any other questions.

pstrepair
Level 1

My customer's paid invoice is showing as an open balance A/R Aging Report

The link in this resolution doesn't take me to the solution to the problem.  I would like to have  this document.

 

qbteachmt
Level 15

My customer's paid invoice is showing as an open balance A/R Aging Report

The Report is an As Of perspective; look at the date on the invoice and the date of the payment, to see if they fall sequentially out of order. Is the payment before the invoice? Is the payment dated into the Future? Is it Applied? Seeing a 0 on AR Aging Summary = the Math is 0, but the transactions are not applied to each other = still Open and Aging as Unpaid.

 

Open the invoice and use Ctl H. Here is what is linked to it. GO To, from here.

angelinmo
Level 2

My customer's paid invoice is showing as an open balance A/R Aging Report

I'm finding this same issue.  I have 3 transactions hanging out in over 90 days.  These 3 transactions were cleared with a deposit on 6-22-19.  All 3 transactions are dated before the deposit date.

I've done the ctrl H thing, and deposit looks look, and they appear to be all paid, yet, on the A/R Aging Summary, the net of $31.04, still shows due.

the 3 transactions are: a 97.32 invoice, a 50.40 credit memo, and a 15.88 pmt.

since it is in a prior tax year, I don't want to delete the deposit, right?

 

or....if I delete it, and then redo the deposit with the 6-22-19 date, will everything clear?

MirriamM
Moderator

My customer's paid invoice is showing as an open balance A/R Aging Report

Hi there, @angelinmo. Thanks for joining the thread and providing detailed information.

 

If you delete the prior tax year transaction, it'll affect your balances, in which you'll need to redo the deposit to clear. Since every business is unique, I recommend consulting with your accountant. They can provide more expert advice in dealing with this concern.

 

To get a better understanding of your business's financial status, look at this article: Track your cash flow in QuickBooks Desktop.

 

You may also see this link helpful in the future: A paid bill or invoice shows on report or window of open transactions.

 

Get back to me here if you have any other concern in managing your transactions. I'm always here to help. Take care always.

angelinmo
Level 2

My customer's paid invoice is showing as an open balance A/R Aging Report

I am the accountant.  I asking about what quickbooks will do.   If I delete the entry, and reenter it with the same date, bookwise and taxwise, all should be OK.   But quickbooks desktop messed this up to begin with, so I'm asking if this will work, and clear up these aged, but paid, transactions.

Need to get in touch?

Contact us