Reporting - View payment reference and date paid
Reporting - to run a report that can show payment information (eg. paid date) and reference/item information.
A report under cash basis does not show the reference that I put on the invoice reference or the item information chosen in the invoice, it is really hard to search receivable payment based on the information I need (PFA).
A xero support specialist explained that because there is no reference on the payment, I can only search by Contact name or invoice number. But, when we do reconciliations to match the bank received with the invoice, there is nowhere to add an additional reference for receiving payment. How can we search for a receivable payment reference if we can not add them?
Therefore, it will be great if a report under cash basis could show the reference I put on invoices or items I picked in invoices to help us more to search information. Especially, when we receive partially payments form customers, there is no report to show that a invoice was partially paid at what amount and on which date.
Thanks.
Tina XIAO
shared this idea
-
Jane Cummins
commented
This is a really big problem for me because we have to report to the USA on a cash basis. All the vital detail of a transaction disappears behind basic cash payment info and it's impossible to differentiate between payments made to the same suppliers. And yet on an accruals version we can see everything. Even an accruals report with "payment date" would work, but with multiple accounts and hundreds and hundreds of transactions to report on it's simply not practical to compare and add notes in excel.
-
Benjamin Amidon
commented
I noticed today that when running a Customer Invoice Report so I can verify invoices paid for the month if you have multiple partial payments for a specific invoice - the report doesn't show the same invoice being paid in say July and then again in September. It will just show that the entire amount was paid in September. This is inaccurate, as the entire invoice was not paid in September, but in July and September. And if you have more than two partial payments related to an invoice, it will not show when those partial payments came in, but only the last payment date and the total that has been paid to date. I would like to see this report show the invoice number more than once when it comes to payments and properly record when those partial payments hit. I use this report for commissions to be paid and only pay commissions on invoices paid. If an invoice has been partially paid, but it shows the total amount paid, it means I paid commissions twice on the same amount
-
Joe Kerslake
commented
I vouch for this. We require a tracking facility from one management program into Xero which tracks "Payment received date". I logged a ticket CX0013031493 with support and was advised that "Payment Received Date" or something of that nature is not a field currently available. However it's clear that this information is indeed tracked within Xero as you can go into the paid invoices and it shows "Paid on XX/XX/***" in the section below.
Many small businesses including myself need to be able to track payment received dates so bonuses/dividends can be worked out.
Thanks,
-
Giedre Macdonald
commented
Reports that include bills/invoices dates and also the dates when it's been paid.
-
Susan Crowley
commented
Is it possible to get a Paid Date option added to any of the Supplier reports - either the Supplier Bill Activity from within Contact Transactions, or the Recent Bills report within the Contact. This report currently offers date or due date a Paid Date selection is required. Also to note when you export to PDF either of the current Date or Due Date reports the export rounds up the figures removing the decimals (why?)
-
Allison Hawkins
commented
Currently in order to pull out data on invoices paid in a given timeframe you have to use the Paid tab under Invoices, highlight it and dump it into Excel to manipulate it.
Please create a report that gives the ability to select invoices that are billed in a given date range and paid in another and/or at least the ability to run a report on invoices paid in a given period. Currently, the Receivable Invoice report date range only refers to the invoice date -if you could also have a date range for payment date we could actually run commission reports out of Xero. It's a common ask across many clients.