Getting rid of old Invoices from my Open Invoices reports

  • 1
  • Question
  • Updated 1 year ago
When I do a report on Open Invoices, it bring up old invoices from as far back as 2008 which have been paid but for some reason still appear on my report. How do I get rid of them without effecting any calculation in my system?
I've attached a photo so hopefully you can understand what I mean. Sorry for some reason it's sideways?????Plus I have heaps of old Purchase orders too I need to clear. I've been here for two years and still trying to get around to cleaning up the system. Thanks


Photo of Rebecca

Rebecca

  • 532 Points 500 badge 2x thumb

Posted 1 year ago

  • 1
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 6,632 Points 5k badge 2x thumb
HI Rebecca - when you run an Accounts Receivable Ageing Summary - do these clients appear on the list but with a NIL balance?  And are you running your BAS on Cash or Accrual?  - the answer to these 2 questions will determine the fix...

The Purchase Orders can just be closed if they are no longer needed...
Photo of Rebecca

Rebecca

  • 532 Points 500 badge 2x thumb
Hi Linda,

When I run Accounts Receivable Ageing Summary, YES the clients show with a nil balance, for the most part, but there are the odd few with 30cents or 1cent balance from 2008.

When I click on them and go back to the original invoice I could fix it but I'm concerned I'll messing up all the amounts and anything to do with TAX.


I've marked all the account that shouldn't be on there.

Thanks heaps

Rebecca
Photo of Rebecca

Rebecca

  • 532 Points 500 badge 2x thumb
Ok

End of Month Reports
Profit & Loss Standards
Balance Sheet
Trial Balance
Aged Receivables
Aged Payable
Unpaid Bills
Payroll Summary
Tax Liability
Tax Summary

End of Quarter Reports
Profit & Loss Standards
Tax Liability
Tax Summary

Yearly Reports
Profit & Loss Standards
Balance Sheet

Thanks so much for this Linda, I really appreciate it.

Rebecca
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 6,632 Points 5k badge 2x thumb
ok - if you are on cash they can possibly work out the correct figures - although looking at the names on that AR list - I am wondering if there is GST on all your sales or if some have no GST? plus without knowing if you are on Cash or Accrual - I cant tell you to fix the problem the easy way or the slightly more fiddly way... one debtor you have marked actually has a balance owing..so that would need further consideration before fixing... ultimately your accountant will need to be brought into the consideration for fixing (have they ever asked you if the Ageing reports are correct and have you ever told them about the amounts that are incorrect?) - I really think you should either find a copy of a BAS lodgement and look on there to see if you are on cash or accrual (I am expecting it will say accrual?) or give the accountant a call to confirm - if you are on Accrual - the fixes for the ones that have a zero balance are much easier...
Photo of Rebecca

Rebecca

  • 532 Points 500 badge 2x thumb
Hi Linda

I haven't forgotten about you I'm just in the middle of an Audit for the Office of State Revenue. I'll get back to this probably next week. I just have to get heaps of paperwork together.

Chat soon
Rebecca
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 6,632 Points 5k badge 2x thumb
all good - no rush... very busy myself!  :)
Photo of Rebecca

Rebecca

  • 532 Points 500 badge 2x thumb
Hi Linda,

Yes you're right, we are on Accrual.
I look forward to finding out the secret to cleaning up my invoice list.

Rebecca