The Expenses Sheet - Importing Data
![QuickBAS Expenses](import_expenses_files/quickbas_expenses.png)
Importing Data into QuickBAS
- QuickBAS lets you import bank data or other accounting data without manually typing each entry.
- QuickBAS accepts Comma Separated Values (csv) and Tab Separated Values (tsv) file.
- First export your data from your bank website as CSV or TSV files
- Save that CSV/TSV file to your computer
- Note that this is very powerful feature, and should be used with caution!
- QuickBAS lets you import bank data or other accounting data without manually typing each entry.
- QuickBAS accepts Comma Separated Values (csv) and Tab Separated Values (tsv) file.
- First export your data from your bank website as CSV or TSV files
- Save that CSV/TSV file to your computer
- Note that this is very powerful feature, and should be used with caution!
![Stacks Image 2365](import_expenses_files/stacks-image-3bbe0e5.png)
![QuickBAS Expenses](import_expenses_files/quickbas_expenses.png)
How to access the import function
- You can import into the Income and Expense sheets only.
- In the top menu, choose File --> Import Data
- An 'Import Wizard' page appears that will guide you through the import data process.
Data Requirements.
- You must choose a valid csv or tsv file
- These files can have a .csv or .tsv or just a .txt file extension
- QuickBAS does not import OFX, QIF or Quicken files.
- You can import into the Income and Expense sheets only.
- In the top menu, choose File --> Import Data
- An 'Import Wizard' page appears that will guide you through the import data process.
Data Requirements.
- You must choose a valid csv or tsv file
- These files can have a .csv or .tsv or just a .txt file extension
- QuickBAS does not import OFX, QIF or Quicken files.
![Stacks Image 4990](import_expenses_files/stacks-image-ecbda1b-1200x812.png)
![QuickBAS Expenses](import_expenses_files/quickbas_expenses.png)
How to specify columns
- Click on the column heading to specify data type
- You must specify which column contains the date and transaction amount
- You can optionally include a column containing GST and extra Notes
- Click on the column heading to specify data type
- You must specify which column contains the date and transaction amount
- You can optionally include a column containing GST and extra Notes
![Stacks Image 4992](import_expenses_files/stacks-image-e302447-1200x792.png)
![QuickBAS Expenses](import_expenses_files/quickbas_expenses.png)
Which rows of data will be included in my import?
- Only those rows with a ticked box in column 1 will be included.
- You can use the selector to choose rows (none, all, positive values, negative values)
- Or you can manually tick entries to fine-tune your selection
- Only those rows with a ticked box in column 1 will be included.
- You can use the selector to choose rows (none, all, positive values, negative values)
- Or you can manually tick entries to fine-tune your selection
![Stacks Image 4994](import_expenses_files/stacks-image-aa563d2-1200x792.png)
![QuickBAS Expenses](import_expenses_files/quickbas_expenses.png)
Making sure all data is valid
- Every row of data that is ticked must have valid data
- The Import Wizard will warn you if rows of data have invalid values
- You can use the buttons to automatically Show, Uncheck or Delete invalid rows
- Date formatting must match the date format, including the separator
- Dates must be in the tax year you are working on
- Transaction Amounts must be numerical values
- Setting a GST column is optional. QuickBAS will calculate GST values if you don’t
- If you set a GST column, all values must be numeric
- GST amounts must be less that the total Transaction amount
- Only when all rows have valid data will the Import button show
- Every row of data that is ticked must have valid data
- The Import Wizard will warn you if rows of data have invalid values
- You can use the buttons to automatically Show, Uncheck or Delete invalid rows
- Date formatting must match the date format, including the separator
- Dates must be in the tax year you are working on
- Transaction Amounts must be numerical values
- Setting a GST column is optional. QuickBAS will calculate GST values if you don’t
- If you set a GST column, all values must be numeric
- GST amounts must be less that the total Transaction amount
- Only when all rows have valid data will the Import button show
![Stacks Image 4996](import_expenses_files/stacks-image-5e3b2dd-1200x792.png)
![QuickBAS Expenses](import_expenses_files/quickbas_expenses.png)
Am I finished when I have imported?
- The newly imported entries will not be set with Categories or Income/Expense types.
- All newly imported data is put into a placeholder category called '[ no category set ]'.
- QuickBAS will show you a filtered view of all the newly imported data.
- You need to click each entry and edit the Category, and the Income or Expense Type
- You can also batch edit a group of transactions, and choose a new Category for them
- The newly imported entries will not be set with Categories or Income/Expense types.
- All newly imported data is put into a placeholder category called '[ no category set ]'.
- QuickBAS will show you a filtered view of all the newly imported data.
- You need to click each entry and edit the Category, and the Income or Expense Type
- You can also batch edit a group of transactions, and choose a new Category for them
![Stacks Image 4998](import_expenses_files/stacks-image-64880e8-1198x792.png)
QuickBAS User Guide - Import Expense Data