Xero help - reconciling 'messy' supplier accounts

Xero help - reconciling 'messy' supplier accounts

Didn't find your answer?

I have a client on Xero who has several fairly 'messy' supplier accounts. They receive proforma invoices, then make payments, then get a final invoice for a different amount, client sometimes makes payment against several invoices at once (sometime adjusted for previous underpayments / credit notes etc).

I've treated some payments as 'overpayments' as I haven't yet matched them to a specific invoice

Overall I would just like a simple supplier activity report, showing invoices with dates and payments with dates, downloadable to Excel, but this is not possible on Xero (which is very disappointing).

The 'recent invoices' report is no good as it doesn't show dates of payments.

I would like to be able to look at the outstanding invoices and unallocated payments for a supplier in one report and be able to match off in a similar way to 'batch payments' but I can't see how to do this either.

Has anyone got any tips they could share?

Replies (7)

Comments for this post are now closed.

Man of Kent
By Kent accountant
18th Feb 2015 12:00

Start again?

Depending on how many transactions you're dealing with, why not unreconcile all the payments and start again.

Thanks (0)
avatar
By Carl London
18th Feb 2015 12:13

Some are actually reconciled OK so I would be reluctant to do all of them!

 

I could unreconcile the 'overpayments' but they are spread over a few months so there is no easy way to see everything on 1 screen if I do that...

Thanks (0)
avatar
By jjswjjsw
18th Feb 2015 12:22

Supplier invoice report

Does the supplier invoice report under the reports tab (not the 'new' reports tab) help? Yes it lists all supplier invoices which is annoying but it includes paid date and is exportable to excel so would be easy to filter down to the suppliers you were interested in. I appreciate its not the same as the reports from other software programmes. 

I tend to work from the purchases tab under all and then search by supplier in this scenario as that will list purchase invoices paid & unpaid plus overpayments and it's usually fairly easy to have a manual note of any unallocated bank payments to include. 

Thanks (1)
avatar
By Carl London
19th Feb 2015 15:07

That 'supplier invoices' report is some use so thanks for that! I've no idea why the system won't let you filter by supplier without exporting to Excel...

 

Also found the aged payables report to be useful...

Thanks (0)
Replying to booksfix:
.
By Cheshire
16th Jul 2017 16:47

Spam!

Thanks (0)
Replying to Cheshire:
avatar
By booksfix
16th Jul 2017 17:26

It's free and super relevant to the topic. It's a free pain killer :)

Thanks (0)
Replying to booksfix:
.
By Cheshire
16th Jul 2017 18:23

Post from 2015!

Rules against advertising on this forum!

One user free?!!! On a site for Accountants with many clients!!

Still spam

Thanks (0)