How can I sort a "Sales by Customer Summary" report by Customer Type
I am trying to generate a Sales by Customer Summary report that sorts (and sub-totals) by Customer Type, rather than filtering by Customer Type.
Best Answers
-
No need @SGarr !
β¦ One of the many great features of Reckon Accounts is that you can create your own custom reports π :
Go to Find (from the Edit dropdown menu, along top toolbar) & click on the Advanced tab.
Select the following Filters:
- Account > Sales (or whatever your main Income account for this is called)
- Date > [Enter/select your required dates/range]
- Detail Level > All except summary
- Posting Status > Posting
Click Find to generate search results, then on Report
Under Modify Report β¦
On the Display tab:
- Choose your Report Basis (NOTE: Accrual = Invoices, regardless of payment status v Cash = PAID Invoices only & Receipts)
- Add/remove Columns as required
- Total by Customer type here & select your preferred Sort β¦ options
On the Header/Footer tab:
- Enter a relevant name in the Report Title box (eg "Sales by Customer Type")
Click OK
Once you have your report how you want it, Memorise it &/or add it to your icon bar so you can easily generate it whenever 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
(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!)
3 -
Possibly β¦ it depends how you're recording entries & what specific info you're wanting to determine from them.
The report above only shows sales forms however if you add the COGS Account along with the Qty & Sales Price Columns, it shows the Income v COGS value amounts for each invoice line:
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!)
1
Answers
-
Hi @SGarr
Unfortunately, I think totaling by a Type will only be available in database-based or detail (rather than summary) 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 -
Thanks, it seems that even in a Transaction Detail by Account report, in the Modify Report-Display-Columns list there is no option to include the "Customer Type" as a column in the report, that could then be exported to excel and sub totaled using a pivot table. Am I right?
0 -
Hello Acctd4,
Thank you, that's excellent, I thought it could be done somehow!
This leads me to my last question, is there a way to look at profitability by Customer Type? I'm thinking of the Job Profitability Summay type report.
Or, is it possible to see the same report you have shown me, but show the COGS side of the transaction rather then the Income?
0 -
Thanks Acctd4, in the report I've run I selected Debit, Credit & Balance columns, and when I select the corrosponding COGS Account along with the Income Account, the Total of each Customer Type is giving me the Contribution Margin / GP for each Type, which is also what I was wanting.
Thank you for your help, it is much appreciated.
1 -
@SGarr Great to hear ππ»ππ»βΊοΈ
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.7K Accounts Hosted
- 16 π’ Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 8 π’ Reckon Accounts Desktop - Announcements
- 1.5K Reckon Payroll
- 36 π’ Reckon Payroll - Announcements
- 15 Reckon Payroll Help Videos π₯
- 28 Reckon Mate App
- 2.7K Reckon One
- 12 π’ Reckon One - Announcements
- 12 Reckon Invoices App
- 22 Reckon Insights
- 100 Reckon API
- 309 Point of Sale
- 1.9K Personal Plus and Home & Business
- 69 About Reckon Community