{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["VATFORM"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"VATFORM","index":0,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[32,1,33,1],[8,1,9,1],[11,1,12,1],[14,1,15,1],[1,3,1,5],[2,3,2,5],[3,3,3,5],[4,3,4,5],[5,3,5,5],[17,1,18,1],[20,1,21,1],[23,1,24,1],[26,1,27,1],[29,1,30,1]]}
[]
[null,"Name"]
[null,"VAT Reg",null,null,null,null,null,null,null,"INSTRUCTIONS"]
[null,"Period Start",null,null,null,null,"<<--(dd/mm/yyyy)",null,"Step 1:","Login to bridgeitmtd.co.uk or create your free account"]
[null,"Period End",null,null,null,null,"<<--(dd/mm/yyyy)",null,"Step 2:","Link your HMRC account in bridgeitmtd.co.uk"]
[null,"E-Mail Address",null,null,null,null,null,null,"Step 3:","Save your VAT number in bridgeitmtd.co.uk and Purchase some credits"]
[null,null,null,null,null,null,null,null,"Step 4:","Make sure you have enough credits. (1 credit = 1 vat return)"]
[null,null,null,null,null,null,null,null,"Step 5:","Complete the Orange Cells in this worksheet (link them to your accounting workbook)"]
[null,"VAT Due in this period on sales and other outputs",null,null,1,null,null,null,"Step 6:","Click the check box on this worksheet"]
[null,null,null,null,null,null,null,null,"Step 7:","Click FILE MY VAT RETURNS BUTTON on this worksheet and follow the instructions"]
[]
[null,"VAT due in the period on acquisitions of goods made in Northern Ireland from EU member states",null,null,2]
[]
[]
[null,"Total VAT due (boxes 1 and 2 added together). This is your 'output VAT' for the period.",null,null,3,{"$f":"F9+F12","v":0},null,null,null,"Note: You will need your Government Gateway user ID to submit your VAT returns"]
[]
[]
[null,"VAT reclaimed in the period on purchases and other inputs (including acquisitions from the EU)",null,null,4]
[null,null,null,null,null,null,null,null,"Watch Video to Unblock Macro Video (If buttons do not work)"]
[]
[null,"Net VAT to pay to HMRC or reclaim (Difference between Boxes 3 and 4)",null,null,5,{"$f":"F15-F18","v":0},null,null,"If you are seeing this redline. Right Click the File > Properties > Tick Unblock"]
[]
[]
[null,"Total value of sales and all other outputs excluding any VAT. (Include box 8 Figures)",null,null,6]
[]
[]
[null,"The total value of purchases and all other inputs excluding any VAT. (Include box 9 figures)",null,null,7]
[null,null,null,null,null,null,null,null,"If the Button does not work, save and reload the file and then enable the macro"]
[]
[null,"Total value of all supplies of goods and related costs excluding and VAT, to other EC Member States",null,null,8]
[]
[]
[null,"Total value of all acquisitions of goods and related costs excluding any VAT, from other EC Member States",null,null,9]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Still Having Issues with Macros? User the URL Method"]
[null,null,null,null,null,null,null,null,"Right Click > Copy YELLOW Cell > Paste in your Browser URL"]
[null,null,null,null,null,null,null,null,{"$f":"\"https://www.bridgeitmtd.co.uk/bridge.html?page=vat-return/bridge&email=\" & D6 & \"&companyName=\" & D2 & \"&VatRegistrationNumber=\" & D3 & \"&periodStart=\" & TEXT(D4, \"dd/mm/yyyy\") & \"&periodEnd=\" & TEXT(D5, \"dd/mm/yyyy\") & \"&vatDueSales=\" & F9 & \"&vatDueAcquisitions=\" & F12 & \"&totalVatDue=\" & F15 & \"&vatReclaimedCurrPeriod=\" & F18 & \"&netVatDue=\" & F21 & \"&totalValueSalesExVat=\" & F24 & \"&totalValuePurchasesExVat=\" & F27 & \"&totalValueGoodsSuppliedExVat=\" & F30 & \"&totalAcquisitionsExVat=\" & F33","v":"https://www.bridgeitmtd.co.uk/bridge.html?page=vat-return/bridge&email=&companyName=&VatRegistrationNumber=&periodStart=00/01/1900&periodEnd=00/01/1900&vatDueSales=&vatDueAcquisitions=&totalVatDue=0&vatReclaimedCurrPeriod=&netVatDue=0&totalValueSalesExVat=&totalValuePurchasesExVat=&totalValueGoodsSuppliedExVat=&totalAcquisitionsExVat="}]