/
Paste EU PC Form

Can't find what you're looking for? Still have questions? Contact customer support (smile)

Paste EU PC Form

Owned by Hilary Hawkins (Deactivated)
Last updated: 06 Jul 2022 by Kai Andras
2 min read

This is a specially designed Excel Paste In for Petty Cash that is not compatible with the Eclipse MTD Module for submitting VAT to HMRC.

This paste in option will split all VAT amounts into their own separate transaction line into the VAT account instead of one lump sum in one VAT transaction line (default functionality).

 


See below for an example:

  • Account 8503.006 is the VAT Account and Account 3760.202 are the Cost Accounts. You can see that the VAT is split for each cost line.

  • Lines 003 and 004 will not appear because these are reserved for the default system VAT lines that are not used in the EU Paste in.

Setup

1. To enable this option you will need to turn off the default auto-calculation of the VAT in your System Defaults. Go to Control Table -> System Defaults -> Petty Cash -> and tick "Disable auto-recalculation of GST/VAT" and press OK.

 

2. You then need to go into each of your currencies via Control Table > Currencies and select the tax code that you want to apply when your Petty Cash items are split for Tax and No Tax.

 

Process

Once your System defaults are set up correctly, you can import the Petty Cash Envelope Form.

 

1. Open the completed Petty Cash Form Envelope Form.

 

2. In the Eclipse main menu bar select Petty Cash > Petty Cash Entry.

 

3. Click the Insert button to start a new batch.

 

4. In the Excel Petty Cash Envelope Form select and highlight the entire form, select Edit > Copy to copy the entire spreadsheet.

 

5. In Eclipse, right-click in the body of the Unposted Petty Cash List window and select Paste EU PC Form.