Skip to content

MAKING TAX DIGITAL

File Exports for Sage and Xero and QuickBooks accounting packages have been added for Making Tax Digital. (User Permissions apply - Transfer Figures to Sage, Transfer Figures to Xero or Transfer Figures to QuickBooks.)

The export routine produces data in a date range that allows these accounting packages to generate digital VAT returns, either for Standard/Accrual VAT (invoices raised) or Cash Accounting VAT (payments received). These figures will agree with the VAT figures that are generated in Assisi in the same date range and you can get a full digital breakdown of these totals and other usage reports from Assisi using our Ad-hoc reports feature.

The exports are suitable for the selected accounts packages, in a format (CSV) specified by the requirements of that package, to allow for a manual import once the files have been generated. For information on how to import the files into your accounts package once they have been generated, please refer to your relevant accounts package information.

Except for the export to Sage data, the figures generated are total figures for all branches.

Transaction Audit

You should carry out an audit to check for transaction variances before generating files to be transferred to external accounting packages for tax purposes. If you are a replicating, multi-branch practice, always allow at least 30 minutes after any batched work has been processed before running the audit to make sure that inter-branch replication has been completed successfully.

  1. On the Assisi Desktop, select Audit from the Transactions Menu.
  1. Once you have selected this option, the audit scan will be triggered and the following message will be displayed once it is complete.

If there are any lines displayed showing variances, please ring Support for advice before continuing.

To Produce the Figures for Import

  1. Click Transactions on the Assisi Desktop.

  2. Carry out a Transaction Audit before transferring any figures (see notes above). If any conflicts show up, contact our Support Team to correct them before continuing.

  3. Click Making Tax Digital and click on the relevant option for your accounting package.

Transfer to Sage

Transfer to Xero

Transfer to QuickBooks

  1. Check that the default Nominal/Account codes are correct for your accounting package if you are using Sage or Xero accounting package.

  2. Check the Include Payments setting.

  3. Check the Break into Branch Totals setting if you are exporting figures for Sage Accounts.

  4. Set the Start and End Dates.

  5. Click to confirm that Assisi has been audit checked and shown no errors.

  6. Click Generate Figures.

  7. You will be prompted to confirm where the files are to be saved and click OK.

To View the file in OpenOffice Calc

  1. Right click on the file and click Open with OpenOffice Calc.

  2. Choose Comma as the column separator and click OK.