/
Paste EU PC Form

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

Paste EU PC Form

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

 

Related content

Complete Guide To Creating And Importing A Petty Cash Template
Complete Guide To Creating And Importing A Petty Cash Template
Read with this
Paste Split PC form - VAT
Paste Split PC form - VAT
More like this
EzyPO
Read with this
Paste Split PC form - GST
Paste Split PC form - GST
More like this
Digital Paper Flow
Digital Paper Flow
Read with this
Adding Journals to pickup VAT Amounts in different Currencies
Adding Journals to pickup VAT Amounts in different Currencies
More like this