SME Professional can provide revenue balances between specified date ranges for reporting purposes. For consistency and accuracy, it is strongly recommended that the Month-End Reconciliation process be completed before generating this export, as this will lock the relevant transactions. More information about this reconciliation process can be found here.
To export the data, the process for our Franchise users is as follows
Navigate to Admin > Exports
Select Bank lines from the Financial section
On the pop-up, enter the required date range for the report
A full, completed calendar month is typically recommended.
Please bear in mind that bank transactions will be imported into SME Professional until the previous working day, so any date range selected should only be up to this date
Leave Include manual/uncleared lines unticked
Click Go
This will produce a CSV file that can be saved
Nominal codes can be applied to this export for further compatibility with management accounting software. For information, please contact the support team at [email protected].
To further organise and interrogate the data
On the export, select all data on the tab by clicking the triangle in the top left
Then select the Insert tab from the toolbar and select PivotTable
From the pop-up, select New Worksheet and then click OK
Click anywhere within the PivotTable to display the fields
Select the following data:
Sum of Amount (Gross)
Sum of Amount (Net)
Sum of VAT
Third-party account name
Sub-category
Click and drag these categories to the required areas
Navigate to the PivotTable Analyse tab from the toolbar and select Insert Slicer
Tick VAT, then select OK
Toggle Multi-select and remove 0 from the selection
This will then leave only the relevant data in the table
When saving the spreadsheet, ensure that the file is saved in Excel workbook format (for example, .xlsx) rather than as a CSV file. This will ensure no data is lost.