Banking

Upload a bank statement

1. Download the statement from the bank's website or app, as Excel, CSV, OFX or QFX.
2. Press Upload a statement.
3. Choose the account under The statement of, if your organization keeps more than one bank or mobile money account: every unit's book uses the organization's one chart.
4. Press Choose the file and pick the statement.
5. For Excel or CSV, check Date, and whether Days are written day first or month first.
6. Check What it was: the column of the bank's words.
7. Under The amounts, choose One column, money out with a minus or Two columns: money in, money out, and the column for each.
8. Read what it found: how many lines, the days they cover, and the money in and out.
9. Press the Keep button, which counts every line in the file.

Then: For review opens on that account, with the new lines waiting to be matched. The notice after says how many lines were actually kept, and how many were left out because they were uploaded already, are dated before the book starts, or are dated after today. Nothing is posted to the book yet. The next spreadsheet for the same account is read with the same columns.

Rather not? Uploaded the wrong file? Take it out under Statements uploaded while none of its lines is matched or added.

Who: Nobody is told: the lines wait on For review for whoever keeps the unit's book.

Hillside Center's First National Bank statement for September arrives on October 2. Grace downloads it as Excel and uploads it, and 40 lines wait on For review. October's file also holds the last three days of September, uploaded already, so those three lines are noticed and left out.

See where each account stands

1. Choose the unit at the top, if you can open more than one book.
2. Read each account's card: what the book holds in it today, and the day its statements reach.
3. Press the lines to review link on a card to match them on For review.
4. Press Reconcile → to reconcile the account's next month, or Count it → for a cash box.

Then: Each card says the last month reconciled, or, for a cash box, the last month counted and what was in it. “The book has moved … since” means an entry was posted into that month after it was finished: undo back to it on Reconcile and do it again.

Take out a wrong upload

1. Find the file under Statements uploaded: search its name, or filter by account.
2. Press the bin beside it.
3. Press Take it out.

Then: The upload and its lines come off the statements, and nothing in the book changes. The taking-out is recorded. Upload the right file after.

If the upload says a row could not be read

1. Read the rows listed in red under “Nothing is kept until every row reads”.
2. Check that Date is the column of days, and that Days are written the way the bank writes them.
3. Check the amounts: one column with a minus for money out, or two columns for money in and money out.
4. If the bank writes cents after a comma, check Cents after a comma — 1.234,56.
5. If a row is a stray one, such as a total at the foot, delete it from the file and press Choose another file to pick it again.

Then: Once every row reads, the Keep button can be pressed. Nothing was kept before then.

Daniel's bank writes 04/09 for September 4, but the page guessed month first, so a row dated 31/08 could not be read. Daniel chooses Day first under Days are written, every row reads, and the 52 lines are kept.