Invoice Reports

Barbara Allen-Guthrie
Barbara Allen-Guthrie Member Posts: 124 ✭✭

Hi I am trying to create a report showing not just invoices issued and date issued, but showing what date the invoice was paid.

Also in the Window that shows all Invoices, is there a way to add a column showing the date paid? I can see how to Customise Columns but not the date paid, this is frustrating me so hope someone can help me?

Best Answers

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,322 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    Answer βœ“

    @Charley I think Barbara was wanting to see the date paid on a single-line invoice report 😬

    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

    [email protected]

    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,322 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    Answer βœ“

    @Barbara Allen-Guthrie Just replying here (as well as email so I can include the screenshot for where to click to close the full screen view) 😊 :

    This arrow button (highlighted) above toggles between full screen & detail views. If you click on it when view is as shown above, it will display transactions - & filters - as per my original screenshot 😊

    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

    [email protected]

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

Answers

  • Charley
    Charley Member Posts: 538 ✭✭✭

    If you go to the Customer Register you can see the Invoice date and the date paid. You can pull up a report from the register Customer by customer or go to reports>customers&receivables>customer balance detail

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,322 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited June 2023

    Hi @Barbara Allen-Guthrie

    No good news for you today I'm afraid ...

    Unfortunately, this is currently not a specifically available option.

    The only workaround I've been able to find is to generate a report of invoices on a Cash basis - The Date on this represents the payment date - then add the Ship Date column. However, this only works:

    • If you don't actually use the Ship Date (eg to record a separate "sent" date) !
    • For invoices paid in full in a single payment

    I believe this has been on the wish list (Reckon Ideas: https://ideas.reckon.com/ideas/search?&query=invoice%20paid%20date) for several years but from Reckon's feedback on there, it looks like it's not an achievable option, possibly compounded by the fact that a single "paid date" column wouldn't accommodate part payments 😒

    Unfortunately, "Date Paid" also isn't an available column to add in Customise Columns 😣 however, if you view All Transactions (rather than just Invoices) you can see all entries at once. Personally, I always add "Inv No. xxxx" in the Memo of my Receive Payments so it's easily visible here (I have the Memo column added in the Customer/Supplier/Employee Centres):


    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

    [email protected]

    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!)
  • Barbara Allen-Guthrie
    Barbara Allen-Guthrie Member Posts: 124 ✭✭

    Shaz Yes I put the Inv also in the memo box also, as well as the due date.

    But sorry where do I find the All Transactions report?

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,322 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited June 2023

    Hi Barbara

    Not a report, just the dropdown filter selection in the Customer transactions display list:


    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

    [email protected]

    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!)
  • Barbara Allen-Guthrie
    Barbara Allen-Guthrie Member Posts: 124 ✭✭

    Sorry still none the wiser, where do I find that?

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,322 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited June 2023

    When you're in (any of) your Centre lists (Customer/Supplier/Employee) & you click on one of the list names. To the left, displays this list of their transactions 😊

    " ... Also in the Window that shows all Invoices, is there a way to add a column showing the date paid ...? (I was assuming this transaction list window was what you were originally referring to)

    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

    [email protected]

    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!)
  • Barbara Allen-Guthrie
    Barbara Allen-Guthrie Member Posts: 124 ✭✭

    Yes I am in Customer Centre, I then select Invoices or Received payments but I cannot see any All Transactinos in my drop downs, only All Invoices or All Adjustments notes etc..

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,322 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited June 2023

    Ah ... don't select Invoices or Received Payments - All Transactions is the first option right at the very TOP of the filter list:


    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

    [email protected]

    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!)
  • Barbara Allen-Guthrie
    Barbara Allen-Guthrie Member Posts: 124 ✭✭

    Sorry Shaz I don't have that option I am using Hosted, am I in the wrong chat room?

    I tried to send you a picture here but it won't allow me to says body too long OMG

  • Barbara Allen-Guthrie
    Barbara Allen-Guthrie Member Posts: 124 ✭✭

    I don't have that option, you have "Show" I only have "Filter by" if I can email you a snapshot of it would help

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,322 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited June 2023

    That is very odd @Barbara Allen-Guthrie - These screenshots I've posted are from a Hosted file.

    Yes, please email me the screenshot direct & I'll check it out!

    TIP: I use the Windows Snip tool - search for it in your Windows computer search bar - You can just click & drag across the area you want to display. I then click on the Edit dropdown - in the Snip window - & click on Copy, then Paste it (either here or anywhere else like an email, Word document etc)! 😊

    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

    [email protected]

    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,322 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited June 2023

    Hi @Barbara Allen-Guthrie

    πŸ’‘πŸ’‘πŸ’‘ It's because you're on the Transactions tab. You need to be on the Customers & Jobs tab instead to see these filters:

    (I replied the same to your email 😊)

    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

    [email protected]

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