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

megan_10040714
megan_10040714 Member Posts: 102 Reckoner Reckoner

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

  • This content has been removed.
  • Kris_Williams
    Kris_Williams Member Posts: 3,651 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    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
    megan_10040714 Member Posts: 102 Reckoner Reckoner

    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
    Kris_Williams Member Posts: 3,651 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited 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
    Acctd4 Accredited Partner Posts: 3,781 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited 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!)

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

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

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

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (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!)
  • Acctd4
    Acctd4 Accredited Partner Posts: 3,781 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    @Rav

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

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

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

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (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!)
  • megan_10040714
    megan_10040714 Member Posts: 102 Reckoner Reckoner

    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
    Acctd4 Accredited Partner Posts: 3,781 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited 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 ....

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

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

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (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!)
  • This content has been removed.
  • This content has been removed.
  • Kris_Williams
    Kris_Williams Member Posts: 3,651 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited October 2020

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

  • This content has been removed.