HOME / COMMUNITY Switch to knowledge base

Supplier Statements


#1

Hi,

Apologies if this has already been answered.

Is it possible to view supplier statements? I can see how to get statements for clients, but can’t see these on the supplier side.

Cheers


Supplier ledger activity
#2

I think it was mentioned some time ago on our old forum. The problem with supplier statements is that they seldom match those actually issued by suppliers due to subtle differences in accounting practices. Also client statements are documents actually issued to clients as a means for requesting payments, whereas supplier statements would only be used for internal reconciliation processes.

There are already a number of ways to see outstanding supplier invoices, grouped by suppliers, aged etc. So creating a dedicated supplier statement would be time-consuming and doesn’t really appear to solve any real problems… just my thoughts.


Add option for Supplier statements
#3

Thanks for the quick response.

The issue I have is that quite a few payments have been allocated to suppliers and not matched to specific invoices. This has resulted in a lot of ‘negative’ supplier balances; but I can’t see a way to get get a list of these.

Once I get this, I suppose I could manually match all invoices & payments to reconcile the accounts.


#4

If you go into the supplier management screen you can click on the Advanced Search box you can opt to show in an additional column all those suppliers with unallocated credits:

You can then order the table to rank by credit size.

You should then be able to drill down into each and allocated those credits to any unpaid invoices.


#7

Would love to see a Supplier ledger activity report (showing debits/credits together) or the same report we can see in Customers (Customer Statement).
This is one of the gripes many of us have with Xero, only able to view a Customer statement, nothing for a supplier.


#8

Hi @Fairway

I’ve moved your request into the existing supplier statement request.

We’ll continue to monitor the interest here going forward.


#9

I would equally like a supplier statement.


#10

Definitely need a supplier statement or a report to view all transactions on supplier account.

Trying to locate mispayments, overpayments and credits seems really complicated. Or am I missing something, is there any easier way?


#11

Hi @TudorJones

You can go to the supplier management screen and select the supplier in question. click on View and select All Payments. This will list all your payments for that particular supplier.

From here, you can do advanced search based on whether it’s allocated or not. You can also search by value, date and payment method if you wish.


#12

Thank you, but it does seem very long winded to have to check payments and then credits, and then search to see if allocated or not…
One report to show all, similar to client statement would be much preferred please.


#13

Plus one for supplier statements akin to client statements