If you have enabled full screen for the Moneydance program, you'll need to hover your cursor at the top of your screen to reveal the menus The File MenuĪllows you to enter a new transaction into your register. If you're using a Mac, they'll be displayed at the top of your screen. Statements downloaded in a CSV format will need to be edited so that Business Finance Assistant can successfully import all the information.These menus are displayed at the top of the Moneydance window. If your bank doesn't provide QIF or OFX files, you will need to use CSV format for importing bank statements.

WHAT IF MY BANK DOESN'T PROVIDE QIF OR OFX FILES? Once your file is ready, use 'Import Bank Statements' (as detailed in Section 3) to import your CSV file into Business Finance Assistant. HOW DO I IMPORT A FILE INTO BUSINESS FINANCE ASSISTANT?

all amounts must be formatted as a numberĪfter building your spreadsheet, ensure you save it as a CSV format as shown below.

your date format matches dd/mm/yyyy (e.g.

Please make sure when populating your file that: Using a program like Microsoft Excel, Apple Numbers, Google Sheets, or OpenOffice Calc, build a spreadsheet that matches the template attached below.Īny data that doesn't fit this import template cannot be imported into Business Finance Assistant. HOW DO I MAKE A CSV FILE BUSINESS FINANCE ASSISTANT CAN UNDERSTAND?Īttached to this article is an example template for importing a statement into Business Finance Assistant (template-import-bankstatement.csv ). IMPORTING A MANUALLY CREATED CSV (EXCEL) FILE Please note, if Business Finance Assistant doesn't recognise the format or content of the file you are importing, please just copy the data from your bank statement into the template provided in the next part of this article below. If you need to omit certain transactions, open the 'Advanced' section and change the start or end dates:Ĭlick 'Done' at the bottom of the screen to import the transactions. It will show a preview of what is about to be imported. Once the file is selected, an 'Import' button appears. You will see a screen like the one below.įrom here click 'Choose file' and select the bank statement you just downloaded. Within the 'Bank Transactions' section of the Business Finance Assistant, select the account you wish to import the statements to and press the 'Actions' button, then 'Import Bank Statement'. Once you've selected your dates and downloaded your statement, it should appear in your Downloads folder on your computer, ready to import. A good way to do this is to look at the date of the most recent transaction in your Business Finance Assistant account and only use transactions after that date. In order to avoid duplicate transactions, you need to check the date range you want to import.

CHOOSE THE RELEVANT DATE RANGE YOU NEED TO IMPORT.More information on this can be found in the FAQ section of this document. Other file formats like Comma-Separated Values (CSV) are accepted but require specific formatting.

The best way to import a bank statement into Business Finance Assistant is to use Quicken (QIF) or Open Financial Exchange (OFX) format as highlighted in the image below. For other banks, if you’re not clear how to download your statement, please contact your provider.īank statements are usually provided in different file formats. Most banks will have a statement section as highlighted in the image below. Go to your bank's website and login using your online credentials. Section 1: Download a statement from your bank Please see the instructions below for further information on both. There are two ways you can import transactions into Business Finance Assistant, either from a downloaded bank statement or from a manually created CSV file.

Moneydance import csv