How do I include a total on Deposit Detail report? We use Reckon Enterprise 2018 PC version
Comments
-
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
(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 -
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.
0 -
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
(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
Categories
- All Categories
- 6.8K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.2K Reckon Payroll 🚀
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 18 📢 Reckon Payroll - Announcements
- 3.1K Reckon One
- 7 📢 Reckon One - Announcements
- 11 Reckon Invoices App
- 14 Reckon Insights
- 114 Reckon API
- 830 Payroll Premier
- 325 Point of Sale
- 1.9K Personal Plus and Home & Business
- 73 About Reckon Community