Export a list of unpaid bills from Reckon Hosted

Amanda Skinner
Amanda Skinner Member Posts: 5
edited July 2020 in Accounts Hosted
I am looking for some assistance with exporting a custom transaction detail report with unpaid bills only. I need help with the exact filter options. At the moment I have selected:

- filter all accounts
- transaction type Bill, Payment and Bill credit
- Paid status open

The transaction amount does not total my AP report unfortunately - what am i missing?

Thank you :-)


Comments

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,366 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited September 2019
    Hi Amanda

    Have you tried using the default "Unpaid Bills Detail" report (From Reports dropdown menu > Suppliers & Payables > Unpaid Bills Detail) ? 
    This one totals (gross) bills/credits grouped per Supplier & you can still "Export" it out to Excel.

    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!)
  • Amanda Skinner
    Amanda Skinner Member Posts: 5
    edited August 2018
    Thanks Shaz. Can that report be modified to get the Account Code and tax type? I've tested it and the figure is correct but need further details
  • Acctd4
    Acctd4 Accredited Partner Posts: 3,366 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited August 2018
    Hi Amanda

    This is specifically an open A/P report so won't reflect the expense/COGS account (Is that what you mean by "Account Code" ?) or tax code (Is that what you mean by "Tax Type" ?).  If you want to view that info, you'll need an account-based/modified report however, this WON'T match your A/P as these figures will be net (EXCLUDING GST)!

    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!)
  • Amanda Skinner
    Amanda Skinner Member Posts: 5
    edited August 2018
    Hi Sharon, thanks again for your reply.

    To give some context, I am importing open A/P details into another program and we want the original GL account code to be listed (so to retain it's history). I have done this before from Reckon (via Custom Transaction report) but now can't get the same report to load.

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,366 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited August 2018

    Hi Amanda

    You can generate a "Custom Transaction Detail" report & "Modify" as follows:


    On the Display tab:

    • Change Dates/date range as applicable (eg from the earliest Bill Date outstanding)
    • Ensure Report Basis is set to Accrual
    • Select “Account List” from “Total by” dropdown
    • Select to “Sort by” “Date” in “Ascending order”

     

    Add/remove columns as required:

    • You may want to remove “Amount” & have “Debit” & “Credit” instead
    • May want to remove “Clr” & “Split” also  (The “Account” column is the one displaying the applicable GL account)

     

    On the Filters tab:

    • Ensure “Account” is set to “Accounts Payable” & select “Yes” for “Include split detail”
    • Scroll down in Filter list to “Paid Status” & select “Open”
    • Select “Account List” from “Total by” dropdown
    • Select to “Sort by” “Date” in “Ascending order”
    If this is something you may need again, I'd recommend, re-naming this report & Memorising it!

    Hope that helps.

    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!)
  • Amanda Skinner
    Amanda Skinner Member Posts: 5
    edited August 2018
    Unfortunately I have tried similar modifications and still an issue, sorry Shaz :-( 

    To give you an example, I actual Total By Supplier so I can check against the A/P Ageing summary. It appears that part payments from a bill are not appearing in this report.

    I've attached an example creditor that is incorrect to show you the difference. Can you bring in part payments?

    image
  • Acctd4
    Acctd4 Accredited Partner Posts: 3,366 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited August 2018
    Have you tried changing the date range to "All" ?  As you've already selected "Open" A/P anyway, it should only pick up outstanding, including partly-paid. 
    UPDATE: Actually I've just tested it & it doesn't appear to recognise partial payments only :(

    If partial payments aren't the norm, my suggestion in this case would be to maybe wait until this particular bill has been fully paid before generating the report & exporting it. 

    Does the program you're exporting to also handle payments?  Alternatively - & again, if this isn't the norm - export the report as is & in the other program, enter that partial payment manually.

    Are you changing over your accounting to a different accounting software? .... Otherwise, just wondering why you're needing to do an Excel export into another program?
     

    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!)
  • Amanda Skinner
    Amanda Skinner Member Posts: 5
    edited August 2018
    Thanks Shaz, at least I know its not just me!

    I'm importing into Xero & closing Reckon off at 30 June so can't wait for them to be paid. I might advise the client that I will import in from the unpaid bills report and the GL account can be retained earnings so that Reckon can retain the history (they still use Reckon for other entities)

    Thanks again for your help on this :-)