Knowledgebase Support HMRC Useful links
Knowledgebase home
Tax Return Production
Accounts Production
Client Hub
Practice Management
VAT Filer
CloudConnect
Anti-Money Laundering
Support home
Hot Topics
SimpleStep Guides
Release Notes
Technical
Known Issues

HMRC Status
Useful Links
MTD for Agents MTD for Businesses What is MTD
Preparation
Agent Services Account
MTD for VAT
MTD for Income Tax
MTD for VAT
Digital Record Keeping
Quarterly Updates
Step-by-step Guide
HMRC's MTD Timeline
TaxCalc's MTD Journey

Accountancy Practices and Tax Advisors
PRACTICE MANAGEMENT
Practice Management
Client Hub
Companies House Integration


PRACTICE COMPLIANCE
AML Centre
NEW

AML Identity Checking
GDPR Centre  
COMPLIANCE SERVICES
TAXATION AND HMRC
Tax Return Production
Vat Filer

FINANCIAL REPORTING
Accounts Production

COMPANY SECRETARIAL
Company Incorporator
Companies House Forms
COMMUNICATION MANAGEMENT
eSign Centre


SERVICES
CloudConnect

Importing VAT data on Mac OSX or Linux

Article ID: 2869
Last updated: 26 Mar, 2019

As of the tax year release (8.0.022) TaxCalc made changes that affect the import of Excel and CSV files into the VAT Filer module on Mac and Linux systems

The TaxCalc MTD VAT import wizard now supports importing directly from an Excel formatted spreadsheet file on Mac or Linux based systems. This means Excel files (.xlsx and .xlsm ) can be imported into VAT Filer without the need to have MS Office installed.

Pre-2007 Excel files (xls) are not supported.

While users who have Excel 2007 or later can re-save the spreadsheet with an xlsx extension, users with a pre-2007 version of Excel, or a spreadsheet program that doesn't support xslx or xlsm will need to convert their spreadsheet file to .csv format to allow importing into VAT filer.

Converting your spreadsheet to csv format

If you are using Mac OSX or Linux you can convert your spreadsheet into a CSV file using your spreadsheet software and import from that. The instructions are generic but should apply to most commonly used spreadsheet programs on Mac or Linux based systems.

Please Note: csv files do not allow multiple ‘worksheets’ so users need to ensure that all of the data fields that are required to be imported into MTD VAT are on the same worksheet.

  • Open the spreadsheet
  • Go to File > Save as (in Numbers this is File > Export to > CSV)
  • Choose a location for the file to be saved
  • Select the file format as .csv (comma separated value)
  • You may be asked to confirm that you will lose some features in your workbook, click yes to save the file

Important: The values should be in a number not currency format..Currency symbols should not be present in the cells.

Using a TaxCalc CSV File

If you don’t have a spreadsheet or are having problems getting all of the information into one sheet, then you can download this CSV file below and complete it. It can then be imported via the MTD VAT wizard.

Download CSV file

Article ID: 2869
Last updated: 26 Mar, 2019
Revision: 9
Views: 816
This article was: