Enter Your Financial Data

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.


Manually


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.



Importing


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 the Import button on the left.





















Step 3.  Browse over to your CSV file and click Open. This screen will open.


























In this example we will import checking account transactions. Column A has Dates 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 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 the orange Deposits tab (lower left) to open the Deposits worksheet and categorize your entries for both main income categories and subcategorized income.


Step 5: Click on the green Checks tab 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.