You will process account payments and receipts, customer receipts, supplier payments and GST payments or refunds using this function.
When you process customer and/or supplier receipts and/or payments using this function, you will need to allocate the receipts and payments under the customer and supplier menu options, however, if you have selected to auto allocate receipts or payments for your customer or supplier, the system will automatically allocate the receipts or payments to the oldest outstanding invoices.
Capturing your Bank Statements
How do you get the information from your bank into your accounting software? – with Sage One it is easy and we offer a number of options to suit your preferences.
- You can manually capture your banking transactions.
- You can import your bank statements into Sage One (using OFX, QIF or CSV files).
- You can set up bank feeds to pull your bank statements straight from your bank into Sage One Accounting.
You can access this function by selecting the Banking…Transactions…Banking menu option.
All your newly imported transactions will appear in this tab. Once you are happy that you have assigned your transactions to the correct account you can process them – this will move them to the “Reviewed Transactions” tab where they will be considered reviewed.
By selecting the Actions check box to the left of the transaction line, you have the option to review or delete transactions. If you select the Mark Selected as Reviewed button, the selected transactions will be moved from the New Transactions tab to the Reviewed Transactions tab. If you select the Mark All as Reviewed button, all the transactions will be moved to the Reviewed Transactions tab.
If a user selects a number of transactions and clicks the Batch Edit button they are able to update multiple rows at one time.
Import Bank Statements
Click on the Import Bank Statements button to import your exported bank CSV or OFX file:
Show Shortcut Keys
Click on the Shortcut Keys link to display the list of shortcuts available on this screen. This will aid you in processing your banking transactions even quicker.
|| Create Rule (Bank Statement Mapping Rules)
These rules will change the way you do your cashbook processing and save you countless hours. They apply to users that import their bank statements into Sage One using either the Bank Feeds or the normal Import Bank Statements feature.
What these rules will do once you have set them up is look for a key word in your bank statement for example “Telstra” and if it sees this text in your import file it will automatically assign this transaction to the correct account in your accounting records in this example “Telephone & Internet”.
You can set these rules up in such a way that 80% of your cashbook processing is already done as soon as you import your bank statement.
|| Split Transactions
With the Split Transaction option you can split one bank statement line into various account allocations. So if you pay AGL, Electricity and Water and want to record these separately in Sage One, you can by splitting the payment to different ledger accounts.
|| Allocate your Customer Receipts and Supplier Payments
When you receive money from a Customer or pay money to a Supplier you are now able to allocate that money directly to the invoice which it relates to – straight from the Banking screen.
You are able to attach any documents such as proof of payment, remittance advice, etc. to each transaction imported on the banking screen.
|| Additional Information – Show More/Less
There are so many options for you in Sage One as well as information to display, because of this not all of your information displays on the transaction line. To access the additional fields like the comments section or to assign a transaction to an Analysis Code you will need to click on the Show More Icon.
We will also display your split information if you have split the transaction or we will display the invoices you have assigned your payment or receipt to.
Reconcile your transactions
The Reconciled checkbox is your way of telling the system that you have agreed that what is in Sage One is what is actually in your bank account – remember that if you import your bank statements straight from your bank account there is no need to even do a bank reconciliation as all of your transactions are considered to be reconciled.
You can search through the transactions in the banking screen. We will be able to find anything you search for in either the Payee or Description column.
Sorting the columns
You can sort on each of the columns on the banking screen from largest to smallest or alphabetically – this will allow you to sort the data quickly and easily to help you review your transactions.
Unallocated Income and Expenses
When your banking transactions are imported into Sage One your Bank Balance is automatically updated, each transaction will be assigned to an account based on any Mapping Rules that you have set up – if there are no rules set up or Sage One does not recognise the description in your bank statement the transaction will be assigned to an Unallocated account in your profit and loss – this will allow you to review these transactions and correctly assign them in your general ledger.
Sage One Accounting allows you to import bank and credit card statements that you have downloaded from the Internet.
When you download your Internet bank statement, select the OFX format. This is an electronic file format supported by most banks.
If you belong to a bank that does not support the OFX format, you can download your bank statement into a QIF or CSV format.
Remember that when you import and map your bank transactions, and the system detects no activity for 2 hours, the system logs off for security reasons.
- To import bank statements, go to the Banking…Transactions…Banking menu option.
- The following screen displays:
- Click on the Import Bank Statements button.
Select the Bank or Credit Card account from the drop down list. The statement details will be imported into this bank or credit card account that you have selected.
There are two Date Range options available:
|All Transactions||Select this option when you want to import all of the transactions contained in the import file.|
|Dates to Import||This option allows you to import new transactions by selecting the relevant date range.|
- In the Import File field, click on the Browse button to search for your downloaded bank statement (QIF, OFX or CSV format).
- If you selected to import a CSV file, the Date Format field activates. When you open your CSV file ensure that the date format selected matches the date format displayed in the CSV file.
- The CSV file must be in a particular format. It should only have 3 columns: Date, Description and Amount. If opened as a text file, e.g. in Notepad, the first line displays the column headings, separated by comma’s and the rest of the lines should have the bank statement information, also, separated by comma’s. For example:
If the CVS file is opened in Excel (preferred), your columns and headings should look like this:
- After you have selected your bank statement and bank or credit card account, click on the Import File button.
- transactions will be uploaded into Sage One. A successful import will show you how many rows were imported and how many reansations are unallocated (not allocated by Bank Statement Mapping Rules) as below.
- The transactions will display as follows:
- By default 8 transactions are displayed per page (you may adjust this preference under My Profile to view more transactional lines) that were imported:
- Transactions will be imported and shown on the New Transactions tab, after allocating and reviewing, you may move these transactions onto the Reviewed Transactions tab.
- Sage One Accounting will automatically detect whether the transaction is a receipt or a payment, and display it accordingly.
- Sage One Accounting allows you to split transactions on the bank statement and link the amounts to other transactions. You can split a transaction by clicking on the button.
- Select the other transaction that you are splitting the selected transaction with, and enter the amount.
- Click on the Save Changes button. The transaction will now be shown as split on the Bank Statement and will process the transaction like this when saving.
Duplicates Found Option
When you make use of Bank Feeds or import your Bank Statements, you will be notified of possible duplicate transactions that you can review. When you use Online Payment Gateways integrated in Sage One and your customers pay you, the receipts will automatically be matched and reconciled when you import your online payment gateway bank statement.
If you click on the Duplicates Found link in the Selection field, Sage One Accounting will explain to you where the Duplicate Transactions were found.
Click on the Show More/Less option:
Click on the View Duplicate Transactions option to view the duplicate transactions:
A list of possible duplicate transactions will display. You have three options to choose from:
|Delete Transaction||Choose this option if you have already processed this transaction.|
|Keep Transaction||Choose this option if this is a new transaction.|
|Match Transaction||Choose this option if you have already processed this transaction but want to mark it as reconciled.|
The duplicate line will get a strike through when you delete it.
You process payments and receipts via one or more bank accounts. You can reconcile these bank accounts against the bank statement if you wish to.
The reconciliation process does not affect any values on your system, and its use is optional. It lets you match each payment and receipt you have entered into the system against a physical bank statement. This helps you to ensure that the amounts are correct. For example, you may write a cheque for 100.00, but enter it into the system as 1,000.00. Alternatively, the bank can make an error.
The reconciliation process also helps you know the value of the cheques that are not yet in your bank statement, so that you can plan your cash flow. For example, you may have cash in the bank, but unless you know the value of cheques that suppliers have not yet deposited, you do not know whether there are sufficient funds in the bank. If your reconciliation is up to date, you can view these undeposited cheques.
Note that the bank reconciliation takes into account all payments, receipts and other transfers that you have entered. This includes customer receipts, supplier payments and other account transactions.
You can access this function by selecting Banking…Transactions…Reconcile Banks and Credit Cards. You can also open the Reconcile Banks and Credit Cards from a number of Quick Links areas.
You mark items as being present on the bank statement by selecting the Reconciled check box.