Under <Back Office><Sync Liquid Accounts> it is possible to set up Tilgo to upload data to LiquidAccounts.com. Liquid Accounts is a cloud based accounting application, and is compliant with HMRC Make Tax Digital VAT submissions.
To setup, you will first be asked for a Company Code. Contact firstname.lastname@example.org if you do not know this code.
Afterwhich you will be asked for a Start Date from which to begin syncing. Any Sales or Deliveries recorded in Tilgo before this date will be excluded from the sync process. This may be necessary for when if you are switching from another accounting application to LiquidAccounts.
This will now open a Sync Status screen as per below. The liquid settings button allows you to re-enter the Company Code and Start Date or stop the whole sync process.
Now click on the Sync button – You should only ever need to click on this Sync button once. From now on all data is uploaded in real time. However if you identify something has not synced, you can click on this button to retry. This may happen for instance, if liquidaccounts.com website is down, or your internet is down… then the real time sync can not happen. Furthermore there is a daily overnight re-sync process that occurs to upload any data missed due to the above examples. Pressing the Sync Button simply starts that overnight process now.
Sales and Payments
All sales are uploaded to a Liquid Accounts ‘Customer’ called : “TilgoSales”. Line item level details uploaded include, Stock Description, Price, Quantity, VAT Amount. Sales are uploaded once they are finalised in Tilgo, i.e. fully paid and closed off. In LiquidAccounts.com they can be seen under > Sales > Invoicing.
All Payments are assigned to a ‘Bank’ called “TILGO”. Liquid Accounts Support will need to setup this Bank up in their system for your account.
Uploaded Payments are automatically allocated to the associated Sale and both are at the most granular level.
Liquid Accounts assigns each Sale and Payment uploaded with a Transaction ID. This Transaction ID is sent back to Tilgo during the sync process. This can be seen in the Sync status screen, by selecting a line item and then the drill-down button . This will also give any error messages with the Sync process.
When you add a Supplier or change any Supplier details, the data is uploaded to LiquidAccounts realtime. In LiquidAccounts.com this can be seen under > Purchases > Supplier Details.
All Suppliers uploaded by Tilgo, will also contain the tag “Tilgo-XX” where XX is the unique SupplierID auto-generated in Tilgo. Any changes to these supplier details should be done in Tilgo. This is a one-way sync, so if you make any changes in LiquidAccounts.com website, they will be re-overwritten during the next Sync using the Tilgo data.
All Deliveries entered into Tilgo will be uploaded real time to Liquid Accounts. Details uploaded include, Stock Description, Price, Quantity, VAT Amount. In LiquidAccounts.com this can be seen under > Purchases > Invoices, as per below
Any changes done in Tilgo, under <Back Office><Deliveries History> will also be updated into Liquid Accounts. Once uploaded the ‘Status’ in Liquid Accounts will be “Outstanding”. When you pay off the invoice in Liquid, this will then be relected as “Paid” as per example below.
When a Delivery has ‘Paid’ Status in LiquidAccounts.com it will no longer be possible to amend any of its details in Tilgo.