How to create a monthly sales and VAT reports

How to create a monthly sales and VAT reports

You may want to generate a VAT report for your sales, you can do this with One Stop Order Processing, instructions below.

If you change the view to the VAT summary this will contain most of the information.

If you need additional information you an add this to the view (by selecting View->Customize current view).

Change the filter to use in Advanced filtering and select the Order Date field along with a criteria of Last Month, this month or Between and enter the required dates. You can then click on Refresh to show the orders that you are interested in.

You can also produce a report for this by using the File->Print->Print Order View menu option. This will produce a report as shown on the screen with all fields totaled at the bottom. You can also use the right mouse button on any column and it will show you its total.

You can also use calculations on various fields by amending their default value.

Press F1 on any dialog for more information on how to use that dialog. or more analysis you can export the information as an Excel CSV file. Select the File->Import Export->Export menu option and export the selected orders or all orders in the current view. You can then view/amend this in Excel.


    • Related Articles

    • How to manage the same product on multiple sales channels

      This feature is available in the Professional, Premium and Managed subscriptions of One Stop Order Processing. Using the main SKU and different SKUs for your selling channels lets you manage a product that you sell on multiple online marketplaces. If ...
    • How to create a stock reorder report in One Stop Order Processing

      The following guide explains how to create a stock reorder report. This feature is available in the Professional, Premium and Managed subscriptions of One Stop Order Processing. You then create two types of reports to show when a product needs to be ...
    • How to use different VAT rate for different products in orders

      This is done by under the Import Orders menu under Adjust TAX, tick Split VAT out at and type in your value (e.g. 20%), This is shown below. However some of the products in an order may have different VAT rates (e.g. books). To use a different VAT ...
    • How to create an Amazon Shipping Confirmation

      How to create Amazon Shipping Confirmations from One Stop Order Processing This feature is available in Professional, Premium and Managed versions of One Stop Order Processing NOTE: If you using Professional or a higher version you can automatically ...
    • How to create a Month by Month Sales Report for your products in One Stop Order Processing

      This feature is available in the Professional, Premium and Managed subscriptions of One Stop Order Processing Install the Export details 1. Save that file attached to this guide. 2. Click the customize current view button 3. Click Import 4. Attach ...