Export a list of unpaid bills from Reckon Hosted

Amanda Skinner

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

Acctd4

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.

Amanda Skinner

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

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

Amanda Skinner

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

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.

Amanda Skinner

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?

Acctd4

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?
 

Amanda Skinner

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