How do I make a manual journal entry?
A journal entry is an accounting movement with a date, a description and several lines. Each line is a journal line: an account with an amount on the Debit or Credit side. Journal entries that come from an invoice are made automatically; this page explains the ones you type.
What do I need before I start?
You need the financial year to be open. The financial year is the accounting year. The program creates it by itself the first time it posts something with that date.
The period of the date you are going to enter also needs to be open. The period is the month. If the month is closed, the journal entry isn’t saved and you are warned. Periods are opened and closed in Operations.
You don’t need to prepare the chart of accounts. If you type an account that doesn’t exist, it is created when you save. What you do need is to type the code correctly: see add a ledger account.
How do I do it?
- Go to Accounting and then Journal. The Accounting journal screen opens.
- Click New journal entry. The editor appears with an empty line.
- Fill in the Date and the Journal entry description.
- On each line type the Account and the amount in Debit or Credit. The account’s Name appears by itself. If the account doesn’t exist yet, you will see the mark new · will be created on save.
- Click Add journal line for more lines. With the keyboard, F3 adds a journal line and F4 removes it; each row also has its own bin button to delete it.
- Look at the indicator at the top. If it says Balanced, the journal entry is ready. If it says Imbalance, with the difference in euros, it still needs balancing.
- When everything is done, click Save.
Nothing is saved until you click Save. You can close the editor with the cross in its corner and no trace is left.
When you save, the Journal entries list moves by itself to the journal entry you have just saved and highlights it. It doesn’t matter how big the journal is or how you save it, with the button or by pressing Enter twice in a row: the journal entry you have just saved always stays in view.
How do I open an existing journal entry without the mouse?
- Go to the Journal entries list.
- Move to the journal entry with the arrow keys, with Page Down, or jump to the end with Ctrl+End.
- Press Enter. The journal entry opens for editing in place, without the list moving.
To search for it instead of going through the list, everything is in find and correct journal entries.
If the journal entry you open can’t be changed —because it came from a document or it is a corrective entry—, it opens anyway but in read-only mode, so you can look at it.
What do the function keys do?
At the very bottom of the Accounting journal screen there is a button bar. They are the same keys as in the Desktop ERP, and each one has its button: if you don’t remember the key, click the button. The buttons are named after what they do —Receipts, VAT, Add line—; to see their key, hover the mouse over them for a moment.
| Key | What it does |
|---|---|
| F2 | Opens the account search from the cell you are on |
| F3 | Add journal line: adds a line at the end and takes you to its account. With no journal entry open, it starts a new one |
| F4 | Remove journal line: removes the line you are on |
| F6 | Opens the receipts and payments open items of the customer or supplier of the account you are on, in the list or in the open journal entry |
| F7 | Opens the Automatic VAT journal entry window (and closes it if it is open). While browsing the list, it opens the journal entry under the cursor with its VAT |
| F8 | AI entry: opens the assistant so you can describe the transaction in your own words |
| Ctrl+C | Opens the bulk account change |
| Ctrl+R | Repeats in this cell what is in the same cell on the line above |
| Ctrl+U | Joins this journal line with the previous one on the same account: adds up the amounts and leaves a single line |
Ctrl+R copies what is just above, in the same column: the account if you are in an account cell, the amount if you are in an amount, the description if you are in the description. If there is nothing above to copy, it tells you in the bar and doesn’t touch anything.
Ctrl+U is for joining two repeated lines: the same account, on the same side. It adds the two amounts into the line above and removes the one below. If the line above has a different account, it does nothing and warns you.
F11 and F12 open the journal line search window (like Ctrl+F): it is explained in find and correct journal entries.
Why are some buttons greyed out?
F2, F4, Ctrl+R and Ctrl+U change a journal line, so they need an open journal entry that can be edited. If they are greyed out, hover over them: the tooltip says why. It is usually one of these three things:
- No journal entry is open: open it with a click or with Enter.
- The journal entry comes from a document (an invoice, a collection): it is corrected from that document, not from the journal. Even if the financial year is open, it is still read-only.
- You have not clicked any cell of the journal entry.
F6 (Receipts) and F7 (VAT) only look things up, and they also work while browsing the list and on read-only journal entries.
How do I make a journal entry without knowing accounting?
Press F8 or the AI entry button. The assistant opens with the sentence already started: finish it in your own words and send it. For example: «I paid invoice A000003 from Caixa».
The assistant finds the invoice, the cash or the bank, and prepares the journal entry, the collection or the payment. It does not save anything on its own: it shows it to you on a card and you confirm it. You don’t need to type the invoice number with all its zeros: A3 or A00003 find A000003.
The F11 and F12 keys don’t do anything
It isn’t a fault in the program: the browser keeps those two keys for itself before the screen sees them. F11 puts the browser in full screen and F12 opens its developer tools. There is no way to prevent it from inside the page.
Both open the same window, Journal line search, and have another shortcut that always works: Ctrl+F (or Ctrl+B). You can also click the Search lines button in the bar at the bottom, which does exactly the same. From the window you search for the matches or filter the journal.
The keys now work across the whole screen
Previously, the function keys only responded with the cursor inside the grid: if you were in the date filter or had just clicked a button, nothing happened. Now they work across the whole screen, as in the Desktop ERP. When the cursor isn’t in any cell of the grid, the key acts on the last cell you were in.
How do I collect or pay an instalment without leaving the journal?
- Go to a customer or supplier account —a personal account, one of those with an associated customer or supplier, such as the
430or400accounts that invoices create—. - Press F6 or its Receipts button. The Open items window opens, with the outstanding instalments of that customer or supplier: the date, the invoice, the amount, what has already been paid and what is outstanding.
- Go through the instalments with ↑ and ↓, and mark the one you want with Space.
- With Tab you reach Cash / bank; choose where the money comes in or goes out.
- Press Enter on the list, or the Settle button.
It also works on read-only journal entries: viewing the open items and collecting don’t touch the journal entry.
What each key does in the window:
- ↑ and ↓ go through the instalments.
- Space marks or unmarks the instalment (you will see the ✓ mark). You can mark several, but all of the same kind: receipts with receipts and payments with payments.
- With Tab you reach Cash / bank: choose where the money comes in or goes out. The program remembers your last choice until you close the session.
- With a single instalment marked you can type a Partial amount: that part is collected and the rest stays outstanding, as a new instalment. With several marked the box is switched off and each one is settled for its outstanding amount.
- Enter on the list settles what is marked (if you haven’t marked anything, it marks the instalment you are on and settles it). The Settle button does the same.
- Escape closes the window and takes you back to the journal cell you were on.
When you settle, the receipt or payment is recorded in the receipts module, just as if you had done it from its screen: the instalment is left paid (or split, if it was partial) and the receipt journal entry is created automatically and appears in the journal as soon as the window closes. You don’t type that journal entry.
If the account you are on isn’t valid for this —it doesn’t exist, it isn’t a customer’s or supplier’s, or its business partner has nothing outstanding— the window doesn’t open and the reason appears in the bar at the bottom.
What does the totals box at the bottom tell me?
Just above the key bar there is a box with three totals, in Debit, Credit and Balance columns. It is the same box as in the Desktop ERP:
| Row | What it adds up |
|---|---|
| Account amounts | The financial year’s Debit, Credit and Balance of the account where you have the cursor |
| Journal entry amounts | The Debit and Credit of the journal entry you are typing, and whether it is Balanced or how much it is out of balance |
| Amount of marked journal lines | What the journal lines you have matched in the active set add up to |
Below the box appear the code and name of the account you are on, and a label if it is a VAT, withholding or treasury account. Next to it you choose the Matching (set 1 or set 2), which is the one that governs the marks and the total of marked lines.
When the journal entry doesn’t balance, the difference appears in red in the balance cell. It is the figure that has to be brought to zero before you can save.
That way you know at all times which account you are working with, how the journal entry is going and what you have matched, without leaving the keyboard and without looking for the figures in three different places on the screen.
Which account does a customer’s or supplier’s journal line go to?
Always to their sub-account, never to the group. If the customer is 000002, their journal line goes to 43000002, not to 430.
This matters: 430 is a group account, and group accounts don’t receive journal lines, they only add up what is below them. A journal line put directly on 430 would be counted twice —once in the group and once at the sub-account level— and the customer balance would come out inflated.
Where the sub-account comes from, in order:
- The ledger account on the record of the customer or supplier, if it has one. It works however you type it:
43000002,430.2or430002all three end up as43000002. - If the record is empty, it is derived from the business partner’s number:
430+000002→43000002. It is the same rule as in the Desktop ERP. You don’t need to type anything: the account exists from the moment the customer was saved, with their name.
The same goes for suppliers, on 400.
The accounts in the settings (700 sales, 600 purchases, 570 cash and banks, 477 VAT…) follow the same rule: they are written as a group because that is how they are read and configured, but the journal line goes to their sub-account (70000000, 57000000…).
If you type a group in a manual journal line, the program warns you: ‘Account … is a summary account: it does not accept direct journal lines.’
Can I change the width of the columns?
Yes. Put the mouse on the vertical line on the right-hand edge of a column’s title: the cursor changes to a double arrow. Drag left or right and the column gets wider or narrower.
- The width is saved for you: the next time you go in, and on any computer with your user, the columns are as you left them. It doesn’t affect your colleagues.
- Double-click on that same line to return that column to its original width.
- The button to the right of the date range returns all the columns to their original width.
- No column can be shrunk until it disappears: each one has a minimum.
How do I balance a journal entry without doing the sums?
A journal entry balances when the Debit total equals the Credit total. The program works it out by itself and shows it above the editor: Balanced or Imbalance with the difference in euros.
To balance it without calculating by hand:
- On the last line of the journal entry, type the account and leave the amount blank.
- Click the scales button on that same row, Suggest contra account (balances this line).
- Look at the indicator at the top: it already says Balanced.
The program puts in the missing amount, on the Debit or Credit side depending on the sign.
An unbalanced journal entry isn’t saved. When you click Save a message appears with the exact difference and the journal entry stays on screen for you to correct it.
How do I add the VAT to a purchase or sales journal entry?
With the Automatic VAT journal entry window:
- With the journal entry open, press F7 or the VAT button. Automatic VAT journal entry opens, already filled in with what the journal entry has.
- Check the Account, the Type (Sale or Purchase) and the Total amount.
- Review the first tax base: Tax base, % and Tax amount. When you type the tax base or the percentage, the tax amount is calculated by itself.
- Click OK.
It does two things at once: the journal entry goes into the VAT registers, just like an invoice, and the journal lines for the tax amount (477 or 472) and the contra line are created by themselves.
The window opens already filled in with what the journal entry has: if you have typed the customer’s or supplier’s account with the amount (for example 4300FS00 · 13,62), you get that account, the type (Sale or Purchase), the total amount, the invoice (the description of that journal line) and the first tax base calculated at 21 %: 11,26 · 21 · 2,36. If you had already typed the sales or purchase account, that is the tax base and the tax amount is what is left up to the total. If the journal entry already had VAT, its tax bases appear.
What you can change:
- Account, Type, Invoice, Total amount and Exempt tax base. When you change the total with a single tax base, the tax base is recalculated.
- Up to three tax bases, each with Tax base, %, Tax amount and its VAT account (the drop-down lists the 472/477 sub-accounts in your chart; if there are none, the one in the settings is suggested and created when you save). When you type the tax base or the percentage, the tax amount is calculated by itself; you can correct it by typing over it.
- The Surcharge for each tax base (%, Tax amount and account). The Equivalence surcharge (RE) checkbox puts in the surcharge that corresponds to each rate (21 → 5,2 · 10 → 1,4 · 4 → 0,5).
- Cash accounting VAT, if the transaction falls under the special cash accounting scheme.
When you click OK, the journal entry is left with the business partner’s journal line for the total, one journal line for each tax amount (and each surcharge) and, if you hadn’t typed the sale or the purchase, a contra line with the account from the settings for the tax bases plus the exempt one. In the normal case the journal entry is left balanced; if not, the window warns you with the imbalance and you can correct the tax bases. Cancel or Escape close it without touching anything.
The VAT lines are saved together with the journal entry, at the same moment. The VAT follows the journal entry: if you delete it in an open month, its VAT disappears with it; if you delete it in a closed period, the VAT also gets its corrective entry, with the tax base and the tax amount negative.
Which journal entries can’t I change from the journal?
There are two kinds of journal entry that open read-only. You will see a notice at the top and all the fields locked.
- Document journal entries. These are the ones created by an issued invoice or a delivery note. The notice says ‘This journal entry belongs to a document: it is edited from its document, not from the journal.’ To change it, modify the document: the accounts are rebuilt by themselves.
- Corrective journal entries. These are the reversing entries the program creates when undoing something in a closed period. The notice says ‘This journal entry is a corrective entry: it reflects the reversal of a closed period and cannot be changed.’
In both cases the Save and Delete buttons don’t appear.
How do I delete a journal entry?
- In the Journal entries list, place yourself on the journal entry and press Enter to open it.
- Click Delete.
- In the same bar the question Delete? appears. Confirm with Yes, delete.
What happens next depends on the period:
- Open period: the journal entry disappears, with its journal lines and its VAT. The general ledger goes back to how it was.
- Closed period: the original journal entry isn’t touched. The program creates a corrective journal entry with Debit and Credit swapped, dated today. That way the balance stays the same and the history of the closed month is kept.
Only journal entries typed by hand can be deleted. Document ones and corrective ones can’t.
If something goes wrong
| What you see | What has happened | What to do |
|---|---|---|
| ‘The journal entry is unbalanced’ | The Debit total doesn’t match the Credit total | Use Suggest contra account on the last line |
| ‘Period … is closed: it does not accept journal entries’ | The month of the date is closed | Change the date, or reopen the month in Operations |
| ‘Account … is a summary account: it does not accept direct journal lines’ | You have entered a group account, such as 700 | Type the full sub-account, or abbreviate with a dot: 700.1 |
| ‘Account … is blocked for new journal lines’ | Someone marked that account as blocked | Use another account, or remove the block on the account’s record |
| ‘This journal entry belongs to a document’ | It is the accounting of an invoice or a delivery note | Modify the document; the journal entry is rebuilt by itself |
| The journal entry is saved with a different number | You have changed the date to another financial year | That is correct: the number belongs to each financial year’s counter |
See also: Find and correct journal entries · View an account’s general ledger · Add a ledger account
More about Accounting
- How do I depreciate fixed assets?
- How do I find a journal entry and correct it?
- How do I close and open the financial year?
- How do I view an account’s general ledger?
- How do I add a ledger account?
- How do I define the line items of the balance sheet and the income statement?
- How do I print or export what I see in accounting?
- How do I assign costs by department and by project?
- Keeping the accounts
- How do I write the notes to the annual accounts?
- What is the accounting dashboard?
- How do I allocate indirect costs?