Export a list of unpaid bills from Reckon Hosted

  • 1
  • Question
  • Updated 2 weeks ago
  • (Edited)
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 :-)


Photo of Amanda Skinner

Amanda Skinner

  • 110 Points 100 badge 2x thumb

Posted 2 weeks ago

  • 1
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.
Photo of Amanda Skinner

Amanda Skinner

  • 110 Points 100 badge 2x thumb
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.

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.
Photo of Amanda Skinner

Amanda Skinner

  • 110 Points 100 badge 2x thumb
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?


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?
 
(Edited)
Photo of Amanda Skinner

Amanda Skinner

  • 110 Points 100 badge 2x thumb
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 :-)