Report - Debtors invoices allocated to a payment - Reckon Accounts Hosted
Hi All
Is there a statement/report I can run in Reckon Accounts Hosted, that will show which Debtors invoices were allocated to payments received.
Thanks
Comments
-
Surely you mean which payments were allocated to which invoices? Its called the Supplier balance detail. Thanks for asking
0 -
That will show the payments that were made but it won’t show what bill was paid with each payment unless you click on the payment and look at each one
0 -
Hi @Zappy Looking to find a report of which debtors payments are allocated to debtors invoices. Need to supply to a debtor all my payment allocations to help with reconciliation of the account.
Thank you @Kris_Williams
0 -
The only way to do this is to print the supplier balance detail report and then manually line up the payments with the invoices. I usually use the ABC system. A against the invoice and payment, B for the next, that way you can mark multiple invoices against a single payment
actually I have just realised it’s debtors, not creditors, sorry. However the customer balance detail is the same type of report and you could do as I suggested.
Shaz’ suggestion of the History tab might also be the way to go
1 -
Hi Megan
There's not a report specifically for this nor can you create one however you can print a payment allocation in the Receive Payment window by clicking on the History button.
(Unfortunately, you'd have to print/save to PDF each payment record as a separate document so I guess it depends how many payments you need to do this for!)
Alternatively, a Statement may suffice - depending on how detailed you are ... I always enter "Inv xxxx" in the Memo field on payments so this notation would display on a Statement.
(NB: It's working for me but not sure if you're able to view the screenshots I've uploaded on the image link ...? )
0 -
... Still having the same random issue with uploading images/links (see above!) 😫
0 -
Hi @Acctd4 Yes, I can see the image, thank you. We are looking for the information to be one report for multiple payments. Will give print receive payments a go.
Appreciate your help
0 -
@megan Unfortunately, there's not a report that can automatically display that .... unless - as I mentioned - you note what invoice(s) are being paid in the Memo. You can then either use a Statement or create your own report from a search (under the "Advanced" tab in the Find window) for Payments by that particular customer & then adding the Memo column in ....
0 -
I think you are approaching the problem from the wrong end. Surely you only need to know what invoices are received and what payments are applied. If you know your starting figure is correct, the ending figure on the subsidiary ledger should match the customer statement. Pretty sure the other systems don't do what you want to do. Have a go at it. You might surprise yourself. :)
0 -
Kris, no one mentioned bills
0 -
You did Kevin, supplier balance detail in your first post, that’s what threw me off
0 -
Oh okay the. So I should have said Customer balance detail.
0
