How can I create a report showing monthly sales figures by customers?

Options
StephG
StephG Member Posts: 5 āœ­

I'm using Reckons Accounts Plus 2023. I know I can use the Sales Graph but that just gives a total for the month. I need to show the monthly sales figures by customer.

Best Answers

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,439 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited March 21 Answer āœ“
    Options

    Hi @StephG

    There are a number of reports that can probably show this info. I would use the Sales by Customer Summary with Columns set to display per Month:


    Under the Modify Report button (highlighted above), on the Filters tab, you can specify one, multiple or all, for both Customers & Items:


    On the Display tab, you can add/remove comparison columns too & choose Cash or Accrual basis:


    You can also set it figures to display as Net or Gross amounts & remove inactive &/or zero rows/columns too:

    šŸ˜Š

    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

    shaz@accounted4.com.au

    https://accounted4.com.au

    (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!)
  • Acctd4
    Acctd4 Accredited Partner Posts: 3,439 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    Answer āœ“
    Options

    No problem @StephG šŸ˜Š

    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

    shaz@accounted4.com.au

    https://accounted4.com.au

    (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!)

Answers

  • StephG
    StephG Member Posts: 5 āœ­
    Options

    Awesome! Thanks so much for your help šŸ˜