Report that lists paid invoices by payment date

Mike_9336004
Mike_9336004 Member Posts: 21 Reckoner Reckoner

I can't find (or build) a simple report that lists bills by supplier that we have paid on a certain date. We want this report so that when we are running a payment for our suppliers we can see an invoice by invoice listing of what makes up the payment to each supplier. When I try to modify a 'Transaction Detail by Account' by adding in 'Date Paid' (in order to filter by the current payment date once exported) - the Date Paid field is always blank. When I add in 'Payment Date' it always comes up with the Invoice date (not the actual date the invoice is paid). This seems like it should be a standard report in any accounting system so I must be missing something here. Any help would be appreciated, thanks.

Comments

  • Mike_9336004
    Mike_9336004 Member Posts: 21 Reckoner Reckoner

    Forgot to mention - we would run this report after processing the payment in Reckon. The report would then be used to check against the ABA file.

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,754 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    There are several reports (under the Reports dropdown menu) that you can Modify ... further & use.

    I'd recommend the Supplier Balance Detail report (under Suppliers & Payables) - This shows Bills, Bill Credits & Bill Payments & can be modified for a specific date range &/or Supplier. You can also add/remove columns accordingly & change the formatting.

    Once you have it tweaked exactly how you want it, remember to Memorise it so you can re-use it as required! 😊

    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!)
  • Mike_9336004
    Mike_9336004 Member Posts: 21 Reckoner Reckoner

    Hi, just to clarify my question - I'm trying to see a report that shows all the invoices that are being paid in the current payment run for each supplier. In the supplier balance report it shows all outstanding invoices and payments within a date range and I'm not sure how to change this report (or other reports in Reckon) so that they only show the invoices in my current payment run.

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,754 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    Modify the report to show only the date range of the bills being paid eg if you're paying September Bills, OR filter for the applicable due date(s) (assuming this feature is being used correctly)

    NB The reports can only show transactions entered - eg Bill Payments - once the Bill Payment(s) are actually recorded. The exception to this is the Bank (Online) Report (under Reports > Banking) which will specifically show you ABA file payments (though again, I believe it is only applicable after creating the ABA File ?)

    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!)
  • Mike_9336004
    Mike_9336004 Member Posts: 21 Reckoner Reckoner

    I guess that's where the problem rises - we have 2 payments per month and all our supplier invoices will fall into either payment run depending on multiple factors such as approval status and other factors, not just their due date. However with that said, this kind of AP process is not uncommon so I'm still unsure why there wouldn't be a report that just lists the invoices that are being selected for payment (I feel like this report must exist somewhere but I'm just missing it).

    Do you know why the 'Date Paid' column doesn't work? If that column worked I would be able to run multiple reports that would give me what I need.

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,754 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited October 2021

    Hi Mike

    The Unpaid Bills report will show you the Bills listed in the Pay Bills window (Under Reports > Suppliers & Payables heading) 😊

    Regarding the Date Paid … Some columns will only show data in a detail report. The Date Paid will show on a detail report (only once a payment has been entered & allocated though, not when it’s ticked to be paid)

    Does that help?

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