Export a list of unpaid bills from Reckon Hosted
Options
Amanda Skinner
Member Posts: 5 ✭
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 :-)
- 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 :-)
1
Comments
-
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
(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!)
0 -
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 details0
-
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
(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!)
0 -
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.
0 -
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”
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
(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!)
0 -
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?
0 -
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
(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!)
0 -
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 :-)0
Categories
- All Categories
- 6.4K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 5.9K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.3K Reckon Payroll 🚀
- 21 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 3K Reckon One
- 7 📢 Reckon One - Announcements
- 10 Reckon Invoices App
- 14 Reckon Insights
- 107 Reckon API
- 822 Payroll Premier
- 307 Point of Sale
- 1.9K Personal Plus and Home & Business
- 63 About Reckon Community