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

StephG
StephG Member Posts: 5 Novice Member Novice Member

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: 4,208 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited March 2024 Answer ✓

    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:

    image.png


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

    image.png


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

    image.png


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

    image.png

    😊

  • Acctd4
    Acctd4 Accredited Partner Posts: 4,208 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    Answer ✓

Answers

  • StephG
    StephG Member Posts: 5 Novice Member Novice Member

    Awesome! Thanks so much for your help 😁