Accounts Hosted - Report to show turnover over 2 week periods
Looking into applying for the WA Covid-19 Business Grant.
We need to demonstrate a 30% - 40% downturn in turnover for any 2 week period from 1 Jan 2022 – 30 April 2022 as compared to the same period from 2021.
Can anyone please suggest how I can do this or which report would be best to use? I'm not sure if profit and loss would be suitable as its more based on just income.
Comments
-
Customise a Profit and Loss to display the previous year and the difference as a %. The income accounts are the ones to look at
1 -
@Marsha Just to add to Kris's suggestion, you can set the date range to the applicable period (01/01/22 - 30/04/22), then click on Modify Report ... to configure more specifically as follows:
- On the Display tab, Display columns by "Two week" & tick the "Previous Year" & "% of Income" checkboxes
- On the Filters tab, select "All Ordinary Income Accounts" in the Account Filter list
- On the Fonts & Numbers tab, tick the checkbox for Show Negative Numbers "In Bright Red" (I have this as default for all reports in my Preferences as it really makes the negative numbers much easier to see)
Don't forget to check your figures for both Cash & Accrual basis as either/both are eligible! 😊
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!)
2 -
Thank you Shaz, that's really helpful!
Just one thing - the report includes 2020 which we don't want on there - is that because I've ticked "Previous Year"?
It also includes other months. Perhaps I'll do two reports, one for Jan-April 2021 and one for Jan-April 2022...
0 -
If you're showing "Previous Year", this will automatically display 2021 so you only need to select the Jan-Apr 2022 date range.
NB: Apologies ... correction for the % .... You actually need to select the "% Change" checkbox, NOT "% of Income" :
If you identify an eligible fortnight, you can then tweak the date range to report just that:
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!)
2 -
Thank you!!
I've also chosen "% change" under Previous Year - so will those percentages indicate any downturn between 2021 and 2022?
0 -
For the specified date range, yes 😁
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 -
Thank you so much, I think I've got it now!! I would never have figured that out myself.
Much appreciated.
0 -
You're very welcome Marsha ☺️
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
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