Skip to content

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?

  1. Go to Accounting and then Journal. The Accounting journal screen opens.
  2. Click New journal entry. The editor appears with an empty line.
  3. Fill in the Date and the Journal entry description.
  4. 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.
  5. 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.
  6. 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.
  7. 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?

  1. Go to the Journal entries list.
  2. Move to the journal entry with the arrow keys, with Page Down, or jump to the end with Ctrl+End.
  3. 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.

KeyWhat it does
F2Opens the account search from the cell you are on
F3Add journal line: adds a line at the end and takes you to its account. With no journal entry open, it starts a new one
F4Remove journal line: removes the line you are on
F6Opens 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
F7Opens 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
F8AI entry: opens the assistant so you can describe the transaction in your own words
Ctrl+COpens the bulk account change
Ctrl+RRepeats in this cell what is in the same cell on the line above
Ctrl+UJoins 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:

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?

  1. Go to a customer or supplier account —a personal account, one of those with an associated customer or supplier, such as the 430 or 400 accounts that invoices create—.
  2. 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.
  3. Go through the instalments with ↑ and ↓, and mark the one you want with Space.
  4. With Tab you reach Cash / bank; choose where the money comes in or goes out.
  5. 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:

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:

RowWhat it adds up
Account amountsThe financial year’s Debit, Credit and Balance of the account where you have the cursor
Journal entry amountsThe 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 linesWhat 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 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.

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:

  1. On the last line of the journal entry, type the account and leave the amount blank.
  2. Click the scales button on that same row, Suggest contra account (balances this line).
  3. 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:

  1. 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.
  2. Check the Account, the Type (Sale or Purchase) and the Total amount.
  3. 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.
  4. 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:

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.

In both cases the Save and Delete buttons don’t appear.

How do I delete a journal entry?

  1. In the Journal entries list, place yourself on the journal entry and press Enter to open it.
  2. Click Delete.
  3. In the same bar the question Delete? appears. Confirm with Yes, delete.

What happens next depends on the period:

Only journal entries typed by hand can be deleted. Document ones and corrective ones can’t.

If something goes wrong

What you seeWhat has happenedWhat to do
‘The journal entry is unbalanced’The Debit total doesn’t match the Credit totalUse Suggest contra account on the last line
‘Period … is closed: it does not accept journal entries’The month of the date is closedChange 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 700Type the full sub-account, or abbreviate with a dot: 700.1
‘Account … is blocked for new journal lines’Someone marked that account as blockedUse 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 noteModify the document; the journal entry is rebuilt by itself
The journal entry is saved with a different numberYou have changed the date to another financial yearThat 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