SME Professional can provide revenue balances between set date ranges for reporting purposes. To ensure the greatest consistency within the reporting, it is strongly recommended that users complete the Month-End reconciliation process to lock transactions before proceeding with this. 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
Fill in the pop-up with the date range the report should cover (typically a full, completed calendar month)
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
This export can have nominal codes applied 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 this spreadsheet please ensure the file is saved as an Excel type and not CSV. This will ensure no data is lost.