Home » Categories » Multiple Categories

VAT Form 100 - Group VAT Registration

Group VAT Registration

The Cashbook VAT Form 100 reports its entries based on Nominal Ledger transactions. In a multi company environment where companies share the same VAT registration number, these need to be consolidated to submit the VAT Form 100 via MTD.
Set Up
The Nominal Ledger ‘Update from Other Systems’ facility allows you to define an update as an ‘Update from Another Database’.  You can use this option to import nominal transactions from one company into another.

In addition to defining the Debit/Credit Accounts and Amount items, the following additional settings required so the VAT Form 100 report can be created:

1. Journal Source Code
In order to be included and analysed correctly within the VAT Form 100 the source on the Nominal Journal needs to one of the following:

S/L (Sales Ledger)
P/L (Purchase Ledger)
CBR (Cashbook Receipts)
CBP (Cashbook Payments)

Instead of entering a journal source as text, you should reference the data item number of the import file that contains the original journal source as per screenshot above.

2. Copy Items
The other key elements for building the VAT Form 100 are the Cash-Net, Cash-Tax and Tax Code data items on the nominal transaction file. Copy items should be set from the source DFD table to the company Nominal Ledger Transaction table to update these fields.

Custom Fields
  • Release ID: Standard
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Maintain Receipt Templates, Maintain Payment Templates - Cashbook
Viewed 483 times since Wed, Jun 27, 2012
Extra Features in Purchase Invoice Transaction Lookup
Viewed 1989 times since Tue, Jun 12, 2012
Database Audit
Viewed 677 times since Mon, Jul 2, 2012
Post Bank Charges - Cashbook
Viewed 1039 times since Wed, Jun 27, 2012
Windows 10 1803 Update / Windows Defender
Viewed 420 times since Wed, May 30, 2018
Revalue a Nominal Account - Nominal
Viewed 845 times since Wed, Jun 27, 2012
Credit Control Manager / Next Action Facility
Viewed 1388 times since Mon, Jun 11, 2012
Financial Summaries - Nominal - Application User Facilities
Viewed 372 times since Thu, Jun 28, 2012
WINMAIL.dat - When sending PDF Attachments from Datafile with Microsoft Outlook the Recipient Only Sees a WINMAIL.DAT Attachment
Viewed 13796 times since Tue, Feb 4, 2014
Database Profiles
Viewed 730 times since Mon, Jul 2, 2012