Identify and Post Settlement Discount VAT Credits from Excel to Sage 200
This tutorial is part of a series of tutorials on Excel to Sage 200 integration using the popular Excel add-in: Excelerator.
In this tutorial, we’ll demonstrate how you can effortlessly identify and post settlement discount VAT credits into Sage 200 from Microsoft Excel. To see this live, book a free demo.
View a video of this tutorial here:
The module identifies the VAT only credits to be raised, generates the credit, allocates them to the invoice and produces a log file for audit purposes.
We start by opening the standard Excelerator template that comes with the new module.
We can download all invoices that are currently due a VAT only credit. The Download option allows us to select an individual customer, a range of customers, or all customers.
Once the customers have been selected, the system identifies and downloads invoices for these customers where the settlement discount VAT amount matches the invoice outstanding amount.
Excelerator can identify where there are multiple transactions for the same customer. Any transactions deemed not suitable for VAT Only Credits can simply be deleted.
The template is divided into two sections – invoices due a credit and a section for credits to be generated.
To fill out the information in the credits to be generated section, click Auto Allocate located in the Excelerator ribbon.
Input the transaction date and copy it down.
Input the credit reference and use Excel's Auto Fill feature to assign a unique reference for each credit.
Click Validate to identify any errors.
Click Save to Sage to post the VAT only credits to Sage 200. Keeping a copy of the Excel sheet proves an ideal record for audit purposes.
And there you have it, a quick and easy way to identify and post settlement discount VAT credits to Sage 200.
Where to go from here
Download the latest release of Excelerator now.
View Excelerator in action with our tutorials.
For help with Excelerator, check out our online Excelerator Help.
Contact us to find out more about this new update, see a demo, or learn about upgrades.
