Beeswax lets you import a CSV file downloaded from your online banking system. It is important to know that the CSV format provided by each bank can vary. Some banks provide a CSV with a Debit and Credit column rather than just a single Amount column with positive and negative amounts. For those of you who are importing a CSV file from a bank that gives you Debit and Credit columns rather than just a single Amount column, it is important to note that Beeswax assumes the Debit and Credit columns are those that the bank presents in their statement. In other words, the Debit and Credit columns that appear on your bank statement will in fact be opposite to the Debit and Credit columns shown in the Beeswax General Ledger. It’s a matter of perspective. Now we're not going to get into the nitty-gritty of double-entry accounting, but if you’re new to accounting, it's understandable that this may seem confusing at first…however, for the sake of getting stuff done, you'll need to accept that this is just the way it is.
So remember this:
Debit —> Spend
Credit —> Receive
So… make sure that the Spend and the Receive columns have the correct values in them. Beeswax uses Spend and Receive columns instead of Debit and Credit so as to avoid this confusion.
If you haven’t downloaded a CSV from Bank, log in and do it. Be mindful of the date range and the number of line items in your CSV file. We limit it to 1000, which should be enough for importing a few months at a time.
Under the Money section in the Main Menu and click on the Bank Import.
This will take you to the Bank Import page where you will see any previously imported files if any.
To import a new CSV file, click on the Import CSV button.
You'll be presented with a form where you will have to specify the following:
If you selected “New” for the Import Format you will be presented with the following Import Mapping configuration screen where you will assign each column of your CSV file to a field in Beeswax.
Once you’re happy with the Mapping and you click on the Save Mapping & Import button, the CSV file will be imported into Beeswax and you will be presented with all the imported Line Items as shown.
Select the Check Box for the Line Item(s) that you wish to Import. You can Bulk Import by selecting multiple Line Items.Select what you would like to import the line item as:
Once you click on the New Import you will be presented with a screen that prompts you to select the Bank Account into which you wish to import the line items. Select the Bank account from the dropdown menu, then select the date range for the statement.
If you don't have the Company that you would like to put the User or Contact under then create a new one by clicking on the New Company button.
"Companies" are a way to group Users, Projects and all money related things are grouped. They are usually businesses that you work with. They can be either Suppliers or Clients, it doesn't really matter.