Known issues - Spreadsheet reports - Sales analysis
Battle to reconcile the data on the Sales per period spreadsheet.
The Spreadsheet report - Stock - Sales per period will list the total sales amount excluding as well as including tax (VAT/GST/ Sales tax) for each of the selected periods.
To import Sales per period into a spreadsheet:
- On the Reports ribbon, select Spreadsheet reports → Sales analysis → Sales per period.
- On the parameters ("Params") screen, select the period and click OK. The total sales amount, excluding as well as including tax (VAT/GST/ Sales tax), for each period will be listed in the spreadsheet:
|
Sales |
Spreadsheet Excl. Amount |
T-Account Ledger - Documents |
Unposted Documents |
T-Account Ledger - Batches |
Total Sales - Documents and Batches |
Difference |
|
March 2020 |
9500 |
5000 |
|
5000 |
10000 |
500 |
|
April 2020 |
13500 |
7500 |
|
0 |
7500 |
6000 |
|
May 2020 |
3000 |
0 |
5000 |
0 |
8000 |
8000 |
|
Total |
26000 |
12500 |
5000 |
5000 |
22500 |
3500 |
|
Sales |
Spreadsheet Excl. Amount |
Posted Documents Invoices |
Unposted Documents Compressor |
Quotes |
|
Difference |
|
March 2020 |
9500 |
5000 |
|
|
|
|
|
April 2020 |
13500 |
7500 |
|
1000 |
|
|
|
May 2020 |
3000 |
0 |
3000 |
0 |
|
|
|
Total |
26000 |
12500 |
3000 |
1000 |
|
|