You can import your transactions from your bank's web page.


Before we start...

Before we start it's a good idea to learn the concepts first.


  1. At your bank's website, you can create a file to export/download. SoEasy uses a QIF file type
  2. Normally we would select a months worth of transactions and download them in a QIF file from your bank's web page to your computer
  3. SoEasy reads the file and processes each transaction with the following questions:
    1. Have we processed a transaction with the 'particulars' before?
      1. If YES we don't need to ask the user what to do as we already have a profile that tells us what to do with the transaction
      2. If NO we will need to ask what to do
  4. A transaction can be:
    1. Just a cash book transaction such as paying for fuel, or wages
    2. A customer paying their account
    3. You paying a creditor's account
      SoEasy will handle each type of transaction slightly differently
      a) Cash Book > Just make an entry into the Cash Book
      b) Debtors (Customer) Receipt > Make entry in Cash Book but also receipt the amount against the Customer's Account
      c) Creditors (Supplier) Payment > Make entry in Cash Book but also pay the amount against the Supplier's Account
  5. When a new transaction is recognised, SoEasy will ask you to create a profile for the transaction.
  6. Once a profile is created, any future transactions with the same particulars, will be processed automatically unless you tell the system to prompt when transactions with these particulars happen again.


Step by Step

  1. Go to Cash Book Main Menu and select 'Import Wizard'.



  2. Take a look around and become familiar with the options



  3. Select 'Next'

    If using SoEasy's Managed Server Services, please make sure you have the BANK directory set up at the C: drive. This video shows you how



  4. Select 'Next'


  5. Select Next


    You can see the details of the transaction on the screen.

  6. Choose an Account Code



  7. When you have processed all the transactions you will be brought to a list.



  8. That's it. You still have to make sure everything balances such as your bank account and at first there is a learning curve where you may have double up's where you have manually entered transactions. You soon learn and then it becomes very easy.


Notes


  1. Avoid importing on Mondays as the bank tends to have adjustments to make from weekend transactions that sometimes do not appear until Tuesday
  2. You need to manage the 'Master Profiles' (recordings of how to process specific transactions) because things can change
  3. If importing daily bankings such as the daily EFTPOS deposits, you need to assign the transaction to the account Cash on Hand = A-C
  4. Your Cash on Hand account should always reconcile to zero or you can see that the only reason it does not reconcile yet is because you have not imported your transactions yet


Common Mistakes

  1. Importing transactions on Monday
  2. Allocating a transaction to the wrong account. (Continue to import then when done, and before 'Processing Transactions', edit the Master Profile. This should correct the existing transactions yet to import)
  3. A contact is both a supplier and client. (Set the profile to 'Always Prompt')
  4. Receipting the money through Debtors, and then importing the receipt. This means you have receipted the amount twice. Sometimes SoEasy is going to prompt you about this and you can fix it. Other times it may not and you can have a double up. Delete the double up.
  5. The import does not assign the receipt to a particular customer invoice. You need to do this after the import. Learn Debtors management here: Debtors Management
  6. When paying Creditors, if you are not loading their invoices into SoEasy's Creditors Ledger, your profile of the transaction may be set to updating the Creditors Ledger which means the payment has no invoice to be assigned against. If you are not loading invoices, when you make the profile, do not set it as 'Paying a Creditor'. If this issue is occuring, edit the Master Profile.
  7. If trying to catch up on months of transactions, importing can cause many double ups. In this case it is best to gain assistance from support BEFORE performing the import as afterwards is very time consuming to correct.


Training

Importing Transactions is a very fast way of keeping your records up-to-date. It is highly recommended to gain professional training. It does not take long and can save you a lot of heartache. Contact Support to Book Training