How do I include a total on Deposit Detail report? We use Reckon Enterprise 2018 PC version

Allcity Sawing
Allcity Sawing Member Posts: 9
edited September 2019 in Reckon Accounts (Desktop)
Report Total

Comments

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

    Hi Alicia

    The Deposit Detail report is a listing of payments.

    You can create a specific/customised report to total all deposits for a particular timeframe:

    • Open the Find screen (Click on “Edit” along top toolbar, then “Find” in the dropdown menu)
    • Select Date in the Filters list & select/enter the applicable date/date range
    • Select Transaction Type in the Filters list & select Deposit in the dropdown list
    • Select Detail Level in the Filters list & choose Summary only
    • Click on the “Report” button to view this search as a report

    You can then “Modify Report” (button on LHS along the top of report) & on the Display tab, add/remove columns + set Sort by & Total by criteria

    • On the Header/Footer tab …. Give this report a meaningful title (Edit the “Report Title” field) eg “Daily Deposits” & click on OK
    • Once your report is customised to your requirements, click on “Memorise” to store it in your Reports area for re-use.  You can even add it as a 1-click Icon to your Icon Bar by clicking on “View” (along top toolbar) then “Add …. To Icon Bar”!

    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!)
  • Allcity Sawing
    Allcity Sawing Member Posts: 9
    edited September 2019

    Thank you for your response.  I have just tried to get the deposit total following your steps but only 4 transactions appeared for the period I selected and there should be 99 transactions.  Most of the transactions are Direct Deposits to our bank account and are entered via ‘Receive Payments’.  The 4 transactions that came up in your report are the ones entered through ‘Record Deposits’. 

     

    The report ‘Deposit Detail’ includes both payments received & deposits recorded.  I need a total of these amounts so I have to add them up each week.  It would be great to print a report that gives me a list of the transactions with a total at the bottom.

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,366 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited September 2018
    Hi Allcity (apologies ... just noted I called you 'Alicia' previously ?!)

    All you need to do is, at ....

    * Select Transaction Type in the Filters list .... in the dropdown list, select "Multiple Transaction Types" then tick Deposit AND Payment 

    This will display ALL amounts credited to the bank account.

    Unfortunately, you can't total specifically by transaction type.  If you need separate totals - eg for EFT "Payments" & Cash/Cheque Payment "Deposits" - you may need to run these as 2 separate reports.

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