Skip to main content

Bank Statements

This guide explains how to import the statement of your bank into MyCloudBook, how to follow the file until it is read, and how to read its messages.

Overview

The Statements tab of a bank brings the statement of the bank into MyCloudBook. You upload the file, MyCloudBook reads its lines, and each line becomes a bank transaction with the status Unreconciled. A file belongs to the bank, and it can cover any period. The date of each transaction decides its reconciliation period.

You can also type a line by hand with Add Transaction. The Bank Transactions and Reconcile guide explains this window.

How to open the tab

  1. In the left navigation, click Banking.
  2. In the Banks tab, double click the bank. The bank profile opens in its own tab, named after the bank.
  3. Click the inner tab Statements.
The empty Statements tab of Harbor Community Bank with the Import Statement button and the information text.
Figure 1. The Statements tab of a new bank.
  1. 1Import Statement. Opens the panel of the upload.
  2. 2The information text of the tab.

Uploading a file

  1. Click Import Statement.
  2. Click Select a file, or drag the file into the box.
  3. Click Upload. The file appears in the list with the status Pending.
  4. Wait until the status is Completed. The list reloads by itself.
The upload panel of the Statements tab with the file Harbor Community Bank 2026-10 Statement.ofx.
Figure 2. The upload panel.
  1. 1Import Statement. A second click closes the panel.
  2. 2The file box. A check mark shows the chosen file.
  3. 3Upload.
  4. 4Cancel.

The rules of a file

RuleDetails
File typesOFX, QFX, CSV, TXT, PDF, JPG, PNG, WEBP, and GIF, up to 5 MB.
Who reads the fileMyCloudBook reads OFX and QFX files. An AI service reads the other types. The screen says to allow 2 to 3 minutes.
One file at a timeEach upload takes one file. A file can cover one month or several months.
The same file againA file that was uploaded for this bank is refused. Delete the first import to upload it again.
Active bankThe bank must be active.

Your bank usually offers the statement as OFX, QFX, or CSV in its online banking. These files give the best result. A PDF or a clear picture of the statement also works.

The Statements tab with the new file and the text Processing, refreshing in 30 seconds.
Figure 3. A file that waits.
  1. 1The list reloads by itself while a file waits, and the counter shows the seconds.

The list of the files

When the status is Completed, the lines are in the Bank Transactions & Reconcile tab. Click a row to see its messages. In the example, the file gave 13 lines, and one line was already reconciled by a rule with auto apply.

The Statements tab with one completed file of 13 transactions and the Messages panel with one message.
Figure 4. The list of the statement files.
  1. 1Import Statement.
  2. 2Statement File. The name of the file.
  3. 3Status. See the table below.
  4. 4Transactions. The number of lines that the import added.
  5. 5Uploaded On. The date and the time of the upload.
  6. 6Messages. The number of messages of the file.
  7. 7The Messages panel. It shows the messages of the selected file.
StatusMeaning
PendingThe file waits to be read.
ProcessingMyCloudBook reads the file now.
CompletedThe file was read, and its lines are in the bank transactions.
FailedThe file could not be read. The Messages panel gives the reason. Upload the file again, or upload another copy.
FileNotFoundThe stored file is missing. Upload the file again.

What the import does with the lines of a file:

  • A line that the bank already has is skipped, so two files can overlap. A message gives the number.
  • A line dated before the reconciliation start date is skipped, with a message.
  • A line inside a completed reconciliation period is skipped, with a message.
  • A line without a date or an amount is skipped, with a message.
  • Rules with auto apply run on the new lines. The Bank Rules guide explains them.

The row menu

The row menu of a file holds two items.

The row menu of a statement file with New Reconciliation Period from Statement and Delete Statement File.
Figure 5. The row menu of a statement file.
  1. 1New Reconciliation Period from Statement. Opens the period window with the date of the last line. Available for a completed file.
  2. 2Delete Statement File. Deletes the file and its transactions after a question.

A file can be deleted while none of its transactions is reconciled and none is inside a completed period. Unreconcile the transactions, or reopen the period, first.

Messages and their meaning

MessageCauseWhat to do
The file '...' is uploaded successfully. Allow a few minutes for the import.The file was accepted.Wait until the status is Completed.
Maximum allowed file size is 5 MB.The file is larger than 5 MB.Upload a smaller file, for example one month.
Unsupported file type. Allowed: OFX, QFX, CSV, TXT, PDF, JPG, PNG, WEBP, GIF.The file has another type.Save the statement in one of these types.
This file was already uploaded for this bank on .... Delete that import first.The same file exists for the bank.Delete the first import, or upload another file.
The bank is inactive. Activate it before you import a statement.The status of the bank is Inactive.Set the status to Active.
The statement currency ... differs from the currency of the bank account.The file has another currency.Check that the file belongs to this bank.
The AI could not read the content of this file. Check that it is a bank statement.The file is not readable as a statement.Upload a clearer copy.
... transaction(s) of the file already existed for the bank and were skipped.The file overlaps with an earlier file.No action is needed.
... transaction(s) were reconciled by the rules with auto apply.Rules with auto apply reconciled lines.Check the lines in the Bank Transactions & Reconcile tab.
The statement has reconciled transactions. Unreconcile them before you delete the statement.A line of the file is reconciled.Unreconcile the line first.
The statement has transactions inside the completed reconciliation period ending .... Reopen that period before you delete the statement.A line of the file is in a completed period.Reopen the period first.

Questions and answers

Which statement files can I upload?

OFX, QFX, CSV, TXT, PDF, JPG, PNG, WEBP, and GIF files of up to 5 MB.

Which file type is the best?

An OFX or QFX file from the online banking of your bank. A CSV file, a PDF, or a clear picture also works.

Can a file cover several months?

Yes. The date of each transaction decides its reconciliation period.

What happens when two files overlap?

Lines that the bank already has are skipped, and a message gives the number.

How do I correct a wrong import?

Delete the statement file with its row menu, and upload the correct file.