...

When uploading journals you have created in excel - see also Importing Open Transactions

Columns in XLS to create multiple journals in the system

One Journal will be created for each date listed.

...

1. Date = D/MM/YYYY
2. Account = Account Code
3. Notes
4. Dr = $ Amoujnt
5. Cr = $ Amount (only one column to have a value
6. Tax = Tax code eg GST or NA
7. Tax Amt = GST tax $ amount
8. GST Inc = Y or NA

Step by step example of uploading file from ePayroll

Export the file from ePayroll 

1. Ensure your ePayroll account has had the GL Accounts uploaded and mapped first
2. Export the file from epayroll = this will be a csv normally.

Make some changes to the file to get it ready for import - and save it as a .XLS file (File-save as)

Drag the XLS file over the general Journal grid - confirm the upload

Populate the screen from the tab on the excel sheet

The grid will populate with the details - enter a date and save

Once saved the journal has been created in the system.

Historical Trial Balances

It is common that companies would like a reference for their financial accounts of 1 or 2 years from their previous system - this is how to create that history.

...

Mapping your old systems GL to the SaaSplications GL

Your GL in SaaSplications should be a lot simpler than your old system - as you will not need to rely on the GL for so much reporting as in other systems.

Export your GL from your previous system

If it does not have a column for Account code - make one up for the import process.

Export the GL from SaaSplications - the flat list

Build a mapping in excel

Columns

Upload the excel mapping - and review

Drag the excel sheetonto the GL Account Mapping screen - Edit - Import

Can edit from this screen if required

Import the first Target Trial Balance

Run a trial balance for the date you want to update before uploading see - Financial Reports including Balance Sheet, Profit and Loss, Trial Balance, Aged Debt and Payable, Stock Valuation  keep it open and then after upload run another one to see the results.

Columns required in the spreadsheet

...

continuing the example above - the first one will be in July 2012

Review the Resulting Journal

The resulting journal will display in the General Journal Screen - not yet saved.

...

Run the trial balance again - check the results

Then do the next month until the last one before operating.

If Splitting a GL account

When splitting a GL account into multiple new accounts

1. Import the last trial balance
2. After this create the journal between the trial balance import and the new GL account for the partial amount

Example - Deposits for suppliers on Purchase Orders

Suppliers sometimes require a deposit.  SaaSplications will create a deposit invoice and match the deposit invoice and then later credit that amount on the final PO invoice.

...

In this case - importing the transactions will create the Deposit Payment AND the Deposit Invoice as a matched pair.  Hence some funds will need to be moved from Accounts Payable to the new control account "Supplier Deposits" after the import of the trial balance.

Step-by-step guide example of creating journals

First create the journal in excel

1. Mandatory Columns in the spreadsheet (use these headers)
   
   1. Date (of journal)
   2. Account (Can be Acct)
   3. DR (or can use Debit)
   4. CR ( or can use Credit)
2. Optional columns that may follow mandatory columns in the spreadsheet (use these headers) - check with us before using these as they are not yet tested.
   1. Link (from list on Journal - Asset, BusinessEntity, Stock, ItemForSale, CompanyDivision, Brand) - note Brand will link to the supplier.
   2. Search code (eg for a brand that would be the supplier search code in the system, for Asset it is the Asset Search Code in our system)
   3. External reference (normally this would hold the reference that was in the old system)
   4. Notes
   5. Qty
   6. Amount
3. Note GST is not relevant for General Journals

Once the journal is ready to import - Drag the XLS over the grid in the General Journal 

1. 1. A confirmation will ask if you meant to do this
   2. A confirmation will confirm the file is available for the session you are logged in for (if you log out you will need to do upload the file again)
      1. 

Choose the Excel Tab to import

1. Action > Import from excel > Choose the tab on the spreadsheet you wish to import
   1. 1. 

The Journal screen will populate

Save

1. If the journal does not balance you will get an error message and journal will not saveIf there are GL accounts the system does not recognise
   1. The journal will not save
   2. A note will popup with a list of the problems
   3. There will be an indicator on the lines in the journal for you to review / adjust
2. If there are values outside a reasonable range (example very small values like 0.0000000000001
   1. The journal will not save
   2. A note will popup with a list of the problem accounts - review and adjust

...

Clear

Import the next tab.

Importing mass Debtor Invoice Journals (and creating mirror transactions)

...

Related articles

...