How to extract Account payable data

ChristineBroome
ChristineBroome Member Posts: 14

Hi all, I'm wanting to extract all accounts payable data for the current financial year - looking to have supplier details (incl bank details), what was paid, which account and which class was charged listed. Is there a way to have all that info in one extract?

Thanks so much

Best Answer

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,315 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited February 6 Answer ✓

    Hi @ChristineBroome

    You can create your own report for this which will allow much greater customisation - Click on Find (Under Edit dropdown menu) & on the Advanced tab, set the following filters in the Filters list:

    • Account > All Income/Expense accounts
    • Amount > Amount >=0.01
    • Date > This Financial Year to date
    • Name > All Suppliers
    • Transaction Type > Multiple Transaction Types (Tick Cheque, Journal, Credit Card, Bill, CCard Credit, Bill Credit, CCard Refund)
    • Paid Status > Closed

    Click on Find, then on Report to convert to a report.

    Click on the Modify Report button & add the Account & Class columns on the first Display tab. You can also untick any Columns you don't need & add any additional ones you want.

    Make sure it's set to Accrual basis.

    You can also Total by & Sort by whatever order/range you like on this tab.

    On the Header/Footer tab, edit the Report Title with whatever name you want to call it - eg "Acct & Class-Allocated Costs Paid" - then click on OK

    Once you have the report formatted how you wish, Memorise it! That way, you can generate it, as is, anytime you need 😊


    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

  • Alexander McKeown
    Alexander McKeown Reckon Staff Posts: 147 Reckon Staff

    Dear @ChristineBroome ,

    You might wish to try modifying a Supplier Balance Detail report.

    You can run this by doing the following:

    1. Go to Reports.
    2. Highlight "Suppliers".
    3. Select "Supplier Balance Detail".
    4. When you open the report, either the Modify Report option will appear. If it does not, you can select "Modify Report" in the top-left-hand corner.
    5. In "Display", under "Columns", tick:
      1. Source Name
      2. Billed Date
      3. Class
      4. Billing Status
      5. Paid
      6. Amount Paid
    6. Select your date range in the "Dates" drop-down.
    7. Press "OK" to run the report.

    This should give you the report you've described - you may wish to tweak the Columns as desired to add or remove information from the report.

    Kind regards,

    Alexander McKeown

    Reckon Senior Technical Support

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,315 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert

    Hi @ChristineBroome

    You can generate all of that data EXCEPT bank details (as they're database-specific, not transaction-based). It's not even possible to display bank details in list reports anymore (which is very frustrating 😣)

    Having said that, if you use ABA files for making payments, you can generate the Bank (Online) Report (from the Reports dropdown menu > Banking) This will show bank details, but not the transactional detail.

    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!)
  • ChristineBroome
    ChristineBroome Member Posts: 14

    Thanks so much Alexander and Shaz for the prompt reply.

    I followed the instructions but under 'account' it only shows 'Accounts payable' (I was hoping it would show me the account that was charged like 'equipment' or 'Office supplies'). And even though I ticked 'Class' there is no info listed below. Did I miss something?

    Thanks

  • Alexander McKeown
    Alexander McKeown Reckon Staff Posts: 147 Reckon Staff

    Dear @ChristineBroome ,

    For Sub-Accounts, can you try toggle "Account Name"?

    As for class, this should have appeared when toggling "Class" in the display.

    You may need to compare it or modify a "Unpaid Bills by Supplier" report, but this will remove any paid bills from the report.

    Kind regards,

    Alexander McKeown

  • ChristineBroome
    ChristineBroome Member Posts: 14

    Thanks @Alexander McKeown Unfortunately that didn't make a different - still only shows it like that


  • ChristineBroome
    ChristineBroome Member Posts: 14

    Fantastic Shaz. All info now showing using the method of creating a report from scratch. Really appreciate your prompt help :-)


    Have a great day and thanks again to you both for taking the time to respond

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,315 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert

    No problem @ChristineBroome - Glad to hear we got the result you were after 😊

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