Accounts Hosted - Report to show turnover over 2 week periods

Marsha
Marsha Member Posts: 8

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

  • Kris_Williams
    Kris_Williams Member Posts: 2,307 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited June 24

    Customise a Profit and Loss to display the previous year and the difference as a %. The income accounts are the ones to look at

  • Acctd4
    Acctd4 Accredited Partner Posts: 1,811 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert

    @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

    0422 886 003

    [email protected]

    https://accounted4.com.au

    (NB: Please mark your post as Accepted Answer/Answered if I have been able to resolve your query as this helps others when seeking solutions!)
  • Marsha
    Marsha Member Posts: 8

    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...

  • Acctd4
    Acctd4 Accredited Partner Posts: 1,811 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited June 24

    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

    0422 886 003

    [email protected]

    https://accounted4.com.au

    (NB: Please mark your post as Accepted Answer/Answered if I have been able to resolve your query as this helps others when seeking solutions!)
  • Marsha
    Marsha Member Posts: 8

    Thank you!!

    I've also chosen "% change" under Previous Year - so will those percentages indicate any downturn between 2021 and 2022?

  • Acctd4
    Acctd4 Accredited Partner Posts: 1,811 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert

    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

    0422 886 003

    [email protected]

    https://accounted4.com.au

    (NB: Please mark your post as Accepted Answer/Answered if I have been able to resolve your query as this helps others when seeking solutions!)
  • Marsha
    Marsha Member Posts: 8

    Thank you so much, I think I've got it now!! I would never have figured that out myself.

    Much appreciated.

  • Acctd4
    Acctd4 Accredited Partner Posts: 1,811 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert

    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

    0422 886 003

    [email protected]

    https://accounted4.com.au

    (NB: Please mark your post as Accepted Answer/Answered if I have been able to resolve your query as this helps others when seeking solutions!)