Home » Categories » Solutions by Business Process » Finance » Nominal and Cashbook

Daily VAT Totals on Nominal Update from Sales / Purchase

Datafile Software

Daily VAT Totals on Nominal Update from Sales / Purchase

Some Datafile users have accounting periods which do not exactly match their VAT months/quarters. For example, the working month may start on the 3rd of a month and end on the 2nd of the following month, or they may have 13 periods of four weeks each. This can cause issues on the VAT return, where the HMRC require the VAT totals to be specific to calendar months.

When updating to the Nominal Ledger in Datafile, regardless of whether updates are summarised or detailed, the VAT is totalled and dated with the run date of the update (usually the end of the current period). As such the user must take care at the end of the VAT period to restrict entry of transactions in the next VAT period and run a nominal update with a date equal to the end of the VAT period with the scope for error this allows.

New for Release 6.5 the system will now allow you to configure the sales or purchase ledger nominal update to specify ‘Update VAT to Nominal with Daily Totals’. This will result in a daily total of the VAT amount for all transactions being updated to the nominal—a separate entry within the journal for each date. This allows the VAT control accounts to be updated to the accounting period as usual but also allows the Vat Form 100 report to pick up only the sales / purchase transactions related to the current VAT period.

Installation

Application User Facilities

To enable the facility for Daily VAT Totals on update to the Nominal Ledger a new parameter has been added to the update definition options for the ledgers. To update select Installation from the main menu followed by Application Manager and then Application User Facilities. Select the Nominal Ledger application and then the Update from Other Systems option. If using the system update configuration the update parameters are now displayed, if using the multiple updating definition confirm the opening of the definition and then select the update definition required before selecting the Sales / Purchase Ledgers parameter screen.



Update VAT to Nominal with Daily Totals
– if set then VAT postings are summarised on a daily basis per tax code used rather than an update run summary per tax code used.

 Compact / Professional Systems

To amend the Nominal Update Definition for Compact and Professional you select Installation from the main menu, lock out the system, and then select System Profiles before selecting the Nominal Ledger. On save of the system profiles you will be prompted to ‘Change the "Update to Nominal” Definition’ – the parameter screen options are then as per the installation notes above.

Custom Fields
  • Release ID: 6.5
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Set Current Period - Cashbook
Viewed 1208 times since Wed, Jun 27, 2012
PERIOD – Budget Input for Periods - Nominal
Viewed 892 times since Wed, Jun 27, 2012
Defining Financial Summaries - Nominal
Viewed 2187 times since Wed, Jun 27, 2012
Cashbook Bank Reconciliation Improvements
Viewed 15110 times since Fri, Jun 8, 2012
CASH – Maintain Bank Accounts - Nominal
Viewed 847 times since Wed, Jun 27, 2012
Period/Year-End Facilities - Cashbook
Viewed 1162 times since Thu, Jun 28, 2012
List of Accounts - Nominal
Viewed 1307 times since Wed, Jun 27, 2012
Receipt Headings, Payment Headings - Cashbook
Viewed 1283 times since Wed, Jun 27, 2012
Bank Reconciliation
Viewed 1298 times since Wed, Jun 13, 2012
Multiple Updating – General Details / Which Systems Allowed - Nominal
Viewed 869 times since Thu, Jun 28, 2012