Reporting in Gross Terms
I am using Reckon Accounts Premier 2014.
I want to view a sales by item report in gross amounts (inc GST).
I have changed the reporting preferences and selected gross, which worked a P+L but didn;t change the way the Sales By Item report displays.
Any suggestions or assistance would be great!
Cheers,
Marley
Comments
-
Try adding Tax amount as one of the reporting fields. Won't add them together but you could export to excel and sum amount and tax amount.
1 -
Hi Marley,
As Fozzie you could export the report and multiply the total by 1.1 to increase for GST.
However you can't record the GST as sales or income. It is not your money, it is the ATO's.
So not sure why you would want it to be included.
Kind regards,
Sally McIntosh (sally@samsolutions.com.au)
2 -
Marley and Kevin there may be a reason that Marley wants to do this. We import our invoices into Reckon. I run a report showing the gst and amount for my BAS reconciliations. There is always a variance in the gst that comes through. Our system calculates gst on Total amount not individual lines, which can/does cause variance. The variance is minor in the big scheme of things but I dump the info out from Reckon and check it, just in case there is a major glitch. Perhaps Marley will use the total and divide by 1.1? Maybe it is a way to test items are being invoiced with the correct gst? In any case hopefully this forum has helped as it has me in the past.
0 -
OOps I meant Sally and Kevin
0 -
Thanks for your efforts.
Sally, I never said that I wanted to record it as sales or income? I needed to view the sales by item inc GST as I wanted to reconcile what went through reckon with what went through our till, and then reconcile with what went into our bank. Of course I know it's not our money!
There is the option to view reports as gross in the reports and graphs preferences, I tested it by producing a P+L and the change in preferences worked...but it wasn't having an effect on that particular report.
After speaking with Reckon Advantage Technical Support the solution was to view a "sales by item - summary" report as opposed to a "sale by item - detail"
Problem solved.0 -
Hi Marley,
Sorry for the confusion, but as many others read these posts also, I needed to clarify that the income is not actually yours. I am glad you are aware of this as many are not!
I ran this report and it still shows net of GST, so not sure how you got it to show?
Perhaps you could run a Profit & Loss Detail report > modify report > change your dates > change to cash & gross (as you did in your preferences) > then in the filters tab for account you can show just income accounts.
Kind regards,
Sally McIntosh (sally@samsolutions.com.au)
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
- 11 Reckon Invoices App
- 14 Reckon Insights
- 107 Reckon API
- 822 Payroll Premier
- 308 Point of Sale
- 1.9K Personal Plus and Home & Business
- 63 About Reckon Community