Report - Debtors invoices allocated to a payment - Reckon Accounts Hosted

megan_10040714 · October 2020

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

Kris_Williams · October 2020

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

megan_10040714 · October 2020

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

Kris_Williams · October 2020

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

Acctd4 · October 2020

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!)

Capture.JPG

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 ...? )

Acctd4 · October 2020

@Rav

... Still having the same random issue with uploading images/links (see above!) 😫

megan_10040714 · October 2020

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

Acctd4 · October 2020

@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 ....

Kris_Williams · October 2020

You did Kevin, supplier balance detail in your first post, that’s what threw me off

Report - Debtors invoices allocated to a payment - Reckon Accounts Hosted

Comments

Shaz Hughes Dip(Fin) ACQ NSW, MICB

* Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

Accounted 4 Bookkeeping Services

Ballajura, WA

(NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)

Shaz Hughes Dip(Fin) ACQ NSW, MICB

* Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

Accounted 4 Bookkeeping Services

Ballajura, WA

(NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)

Shaz Hughes Dip(Fin) ACQ NSW, MICB

* Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

Accounted 4 Bookkeeping Services

Ballajura, WA

(NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)

Categories