The cash and bank journal
The cash journal is the screen for typing, one after another, the movements of a cash account or a bank: an expense paid in cash, the one-off sale at the counter, the receipt of an invoice, a transfer to the bank. Each row is a treasury operation that is recorded and posted to the accounts when you close it, without going through any other screen.
What is it for?
For what is done several times a day at the counter or in the office: entering money that comes into or goes out of a treasury account. You choose the cash account or the bank, type one row per movement and the balance in the footer keeps updating. What each row records is decided by the key you type at the start: an expense with VAT, a cash sale, the receipt of an outstanding invoice, a transfer between accounts, a cash adjustment or an advance payment.
It is opened from Treasury → Cash journal.
What is a key?
A short code (100, 300, 700, 900…) that says what operation the row is and, with that, which columns are needed. The keys are defined in Treasury → Cash keys, and each company starts with the standard keys:
| Key | Operation | What the row asks for |
|---|---|---|
100 | Cash purchase (expense with VAT) | Description, out, VAT, expense account; supplier, Tax ID (NIF) and till receipt if you want |
300 | Payment of a supplier invoice | Out, supplier and, if you want, the invoice |
350 | Supplier advance payment | Out and supplier |
400 | Transfer between accounts | Amount and the destination account |
500 | Cash adjustment | Surplus as in, shortfall as out |
501 | Opening balance of a new account | In |
700 | Cash sale (income with VAT) | Description, in, VAT, income account; customer and Tax ID (NIF) if you want |
900 | Receipt of a customer invoice | In, customer and, if you want, the invoice |
950 | Customer advance payment | In and customer |
You can create as many keys as you need (101 petrol, 102 repairs…): each one inherits the behaviour of its family and can come with the description, the offset account and the VAT rate already set, so that in the row you only have to type the amount.
The deferred purchase (200) and deferred sale (800) keys don’t save anything from the journal: those operations leave open items and are recorded as a document. When you close a row with one of them, the ERP opens the purchase or sales invoice form with the row’s customer or supplier and date already set; you complete the lines, issue it, and the ‘Back to the cash journal’ link in the header takes you back to the same account.
How do I type a row?
When you open the screen the cursor is already in the key of a new row. You type the key and press Enter; the journal fills in what the key brings (description, VAT, account) and jumps to the next cell that is needed. You carry on with Enter cell by cell: description, amount, and whatever the key asks for. When you confirm the last cell the row is saved, it appears in the list and the next one is ready, with the same date.
- Enter confirms the cell and moves to the next one. On a cell with a suggested value, the first Enter opens it to change it and the second confirms it.
- Tab skips the cell without touching it.
- Up arrow and down arrow leave the row in the direction you ask and to the same column, as in a spreadsheet, and close it on the way: if the row has something to save (a new row with a key, or a row opened from the list in which something has been changed) the arrow saves it and the cursor lands on the row above or below; if there is nothing to save, it only moves. With a cell half done, the arrow confirms it before moving (no need for Enter). If something is missing, the journal says so and the cursor stays put so you can correct it.
- Page Down (or Shift + Enter, or the ‘Save’ button) saves the row even if there are cells left to go through.
- Escape in a cell discards what you typed in it; the second Escape discards the whole row and goes back to the list (a row opened from the list stays as it was). The same as in the accounting journal.
- F2, or the magnifying glass that appears when you are on the cell, opens that cell’s search window: the keys, the customers or suppliers (depending on what the key asks for), the chart of accounts or the treasury accounts of the transfer. You search by code or name; choosing one puts it in the cell and the cursor moves on. In the invoice cell, the magnifying glass opens the business partner’s open items (the same as F6).
- Ctrl + R repeats in the cell the value of the last saved row.
- F3 starts a new row; F6 opens the open items of the row’s customer or supplier.
The buttons in the footer do the same as these keys; when you hover over each one you see what it does and with which key.
Which column does the amount go in?
Enter takes the cursor to the column the key decides: ‘Out’ for an expense or a payment, ‘In’ for a sale or a receipt. The other column isn’t locked, and that is on purpose: an amount in the opposite column is a refund, the money goes the other way. An expense typed in ‘In’ is the refund of that expense (the supplier gives the money back): the cash receives it, the expense account and the input VAT are reversed by that amount and the VAT register records it as a negative. A cash sale typed in ‘Out’ is the refund of the sale, with the output VAT as a negative. The journal warns you in the status bar and shows the amount in amber so that it can be seen.
Invoice receipts and payments, advance payments, transfers and the opening balance can’t be refunded from the journal: if the amount falls in the opposite column, saving is rejected and it says which one is correct. A return of a receipt or of an advance payment is recorded from Receipts and payments.
Cells that don’t apply to the key are shown striped and are skipped.
What happens with the VAT of an expense?
You type the total of the till receipt, including VAT. The ERP separates the base and the tax amount with the row’s rate (the one the key brings, or the one typed in the VAT column), takes the base to the expense account and the tax amount to the input VAT register. If the till receipt has a Tax ID (NIF), you type it in its column so that it goes into Form 347; if the supplier has a record, its code in the ‘Customer/Supp.’ column is enough.
With a cash sale (700) it is the same the other way round: income and output VAT.
How do I collect an invoice from here?
With the receipt key (900), the amount and the customer code. If you leave the ‘Invoice’ column empty, the journal settles the customer’s outstanding bills by age until the amount is covered; if you type an invoice number, it settles only that invoice’s bills. When the amount isn’t enough to cover a whole bill, that bill is left partly collected and the rest stays outstanding.
To choose by hand which bills are collected, F6 opens the customer’s open items in the direction of the key: you go through them with the arrows, Space marks the bills and Enter takes them to the row. The amount is filled in with what is outstanding on the marked ones and is left selected in its cell; if less is collected, you type over it and the difference stays outstanding. F6 only opens with a receipt or payment key and with the customer or supplier already typed; otherwise, it says so in the status bar.
If the customer has nothing outstanding, the journal doesn’t reject the money: it warns you and suggests recording it as an advance payment. You only need to change the key to the advance payment one (950) and save again.
Payments to suppliers (300) work the same way with the payments open items.
How do I correct a row that has already been saved?
You put the cursor on it with the arrows (or by clicking) and press Enter: the row opens in place with its values. You change whatever is needed and save. Behind the scenes, correcting means voiding the previous operation and recording a new one: the row is left with a new operation number and in the accounts there is the voiding entry as well as the new one, so that the correction can be followed.
To remove a row completely you open it in the same way and press F4 twice (or the void button). The operation is voided, with its voiding entry, and disappears from the journal.
Which rows can’t be touched?
Those with a padlock. They are the ones the journal can’t redo without breaking something else:
- A row sealed by a cash count: the cash closing has already counted it. First the cash count is voided.
- A row reconciled with the bank statement: first the reconciliation is broken.
- A row that came from a document (the immediate payment of an invoice): it is corrected from the document.
The journal shows them, with the reason when you hover over the padlock, but doesn’t open them.
How do I change account?
With the drop-down in the header or with the four buttons around it: first account, previous, next and last, in the order of their codes. When you change account the list reloads from the end —where today’s movements are— and the footer shows the amounts, the payments and the balance of that account.
The ‘From’ and ‘To’ dates narrow down what you see; the balance in the footer is always that of the whole account.
What is the mark in the first column for?
Only on bank accounts: it is the manual reconciliation with the bank statement. Space on a row (or a click on the circle) marks it as reconciled; again, it unmarks it. A reconciled row can’t be changed from the journal. Cash accounts have no mark.
Can I go through the journal without a mouse?
Yes, like a spreadsheet. The arrows move the cursor through the rows and the columns, Page Down and Page Up move one screen at a time, and Ctrl + Home or Ctrl + End jump to the start or the end of the account’s journal. From the last row, the down arrow goes back to the new row at the end, in the same column the cursor was in (if that column can’t be typed in yet because the row has no key, in the key).
Columns can be widened by dragging the edge of their heading; the width is remembered per user and a double click returns it to the original.
More about Payments
- The cash keys
- How do I collect an instalment?
- How do I add a treasury account?
- How do I return a receipt?
- How do I generate a bank batch?
- Collecting and paying with Powergest
- How do I record a payment to a supplier?
- How do I set the payment terms for a customer or a supplier?
- How do I record an advance payment from a customer?
- What is a voucher and how do I use it?