This article will help you understand any errors that can happen during a reconciliation.

If your bank does not match in Shine, it can be due to several things. It is important that the balance in your online bank is the same as the balance in Shine on account 5710 on a given date.

If there is a difference between what is posted in Shine and what is actually in the bank, you need to find out what the error is.

The typical errors are:

• Double posting: You have posted one or more bank lines several times
• Missing posting: You have missed posting one or more bank lines
• Missing opening balance: You have started in Shine without registering an opening balance in the bank

How do you find out what the error is?

Our recommendation is that you manually check your bank bookkeeping and see if any entries are duplicated or missing.

This can be done, for example, by finding the bank's account card:

• Go to Accounting> Balance sheet
• Click on the balance for account 100201001

From here you can see your bookkeeping in Shine and check for duplicate or missing entries.

You also have the option to export the bank's account card so that you can check it in e.g. Excel.

• To do so, click on the Export button (in the top right corner).

Opening balance

When you do this, you can compare the balance recorded in Shine with the balance in the online bank. If the bank has never voted, we must assume that an opening balance has not been made for the bank.

If the bank has voted before, you need to find the last date when the bookkeeping in the bank matched the online bank balance. Then you know that the error is from that date onwards.

Double-entry accounting

If you find that there are entries that have been double-entered, it would be correct to delete the entries that have been double-entered.

This can be done easily :

• Go under the bank account card;
• Find the entry that needs to be deleted.
  • If it is a financial entry, you can press the Cancel button (in the top right corner).
  • If, on the other hand, it is an invoice or bill, you must press under Origin (on the far right) > More > Cancel bill/Cancel invoice. The entry will then be canceled, and the bank balance will be corrected.

If the bank balance still does not match the actual balance in the bank, you can repeat the above process until the bank balance matches.

Missing accounting

If you notice that there are missing entries in the bank in Shine, it may be because there are missing bank lines in the bank reconciliation. Typically, this will happen if you have imported the same bank line several times, most often in connection with both using our automatic bank integration and manual import with a CSV file.

There are several possible solutions to this problem depending on how the error occurred.

We recommend that you start by deleting your bank connection and creating the bank connection again:

• Click on Bank > Bank connections > Disconnect connection

This will make Shine check if any bank lines need to be imported.

If this does not result in new bank lines, we recommend that you extract a CSV file from the online bank and import it manually into Shine.

• When you have the CSV file from the bank, in Shine, click on Bank > More > Import > Upload bank statement
• From here, select the file to be imported

Shine will try to see if some of the bank lines you are trying to import have already been imported, but we cannot guarantee that it will find them all.

Therefore, please be aware that the bank lines it marks for import are not always actually missing from the reconciliation. So you have to make sure that only the bank lines that are missing from the accounting are marked before you import.

Once you have imported the missing bank lines, you must make the accounting for the bank lines as you normally would.