Everyone enters data differently. You may be the type that enters your data once a day, once a month or once a year. If you are entering your transactions monthly or yearly you will really enjoy the import feature.
Step 1: Click on the month you want to enter data into. Click on the orange “Deposits” tab (lower left) and enter four things, all on the same row: the date, name or description, reference number then choose an income column to place the amount of income. Repeat this for each deposit or payment you receive.
Step 2: Click on the green “Checks” tab and enter four things, all on the same row: the date, name or description, check or reference number then choose an expense column to place the amount in. Do this for checks written, bank debits, cash withdrawals, transfers to other accounts and expenditures using PayPal or other merchant accounts.
Step 3: Click the blue tab for “Cash&Charges” to enter non-checkbook expenditures. Record cash, credit card expenditures and mileage.
Step 1. Go online to get your bank account history. Download transactions in CSV format If CSV is not available choose Excel format. You may need to open the file and sort it in date order from oldest to newest. Once you have your data the way you like it, save the CSV file.
Step 2. When you are ready click on “Import” on the left menu.
Step 3. Browse over to your CSV file and click “Open”. This screen will open.
is just one header row.
In this example we will import checking account transactions. Column A has dates listed so select column A in the drop down for “Date” and so on. If the amounts for your debits and credits are in the same column and the debits are negative amounts, choose Debits<0. Make sure the data in the Description column is how you want it (sometimes banks have a very long description that doesn’t make sense to you-so you may want to change it before importing) then click Import.
If your CSV file has all twelve months of data, the importer will import all twelve months and you will see all the entries as you open each month.
Step 4: Click on “Deposits” to open the Deposits worksheet and categorize your entries for both main income categories and subcategorized income.
Step 5: Click on “Checks” and categorize your entries for both main expense categories and subcategories.
Repeat this process to import Credit Card transactions then click on the blue Cash&Charges tab (which records all your non-checkbook expenditures) and categorize your entries. You’ll notice any payments to credit card companies will be listed on the “Checks” sheet with the amount of your payment listed under column AN. You will have to enter your cash transactions manually.