Bank statements and the bank feed
Most of what reaches the group’s bank is already in its books: a Stripe payout, a deposit of cash and checks, a check the treasurer wrote. With Grouperly Plus, the bank’s lines come into the books, and Grouperly ticks those off by itself. What’s left waits in Review, often one click from posted, with who and what for already suggested.
The lines come in two ways:
- The bank feed, for the group’s checking and savings: Grouperly brings in the bank’s lines through Plaid, by itself.
- A statement, for any account and any bank: the CSV, OFX or QFX file you download from the bank’s website.
Connect the bank feed
Section titled “Connect the bank feed”The bank feed uses the group’s sign-in to its bank, the same one that pays members back. If no one has signed in yet, do it once in Finances → Settings → Payouts with Sign in to your bank, and tick every account the books should read.
- Open Finances → Accounts, choose Bank statements (at the right of the account’s tabs), and find Bank feed. Until an account is connected, the account’s Review says so, and Connect the bank feed there opens it too.
- For each of the bank’s accounts, choose the books’ account it is under Feeds. The one with the same last four digits is suggested.
- Check from, the first day it brings in, then choose Connect. It starts on the day the books start. If you brought in statements or reconciled the account, it starts after the last of those, so no line comes in twice.
- Choose Bring in the latest. The first time, Plaid sends about the last 30 days, then fetches the rest of the bank’s history, up to two years, in the background, usually within a few hours. The card and Review say so until it’s in. It comes in by itself, or bring in the latest again later.
From then on, the lines come in by themselves a few times a day, and when you open Review if they’re more than an hour old. Bring in the latest gets whatever Plaid has now. A line still pending at the bank comes in once it posts.
What comes in with each line. Besides the bank’s own words, the feed keeps what Plaid knows about a line: who it was with (a store, or whoever sent a Zelle), a payment’s reference, a general category such as Food and drink › Groceries, and the day a card purchase was made when it posted later. Review shows it under the bank’s words. Grouperly uses it to suggest who to post a line as, to match a purchase you entered on its receipt’s day, and in auto-categorize, which gets the category and a business’s name, never a person’s.
Check images don’t come through Plaid. To see who a check was written to, download its image from your bank’s site and attach it to the entry.
When the bank asks you to sign in again, To review and the bank feed say so. Choose Sign in to the bank again on the bank feed. If it’s been stopped for three days, the group’s owners and admins are told by email.
To stop it for one account, choose Disconnect. The lines it brought in stay. Removing the bank in Payouts stops the feed for every account.
Plaid sends up to two years of the bank’s history, less at some banks. Once it has, the feed starts on the first day it sent, even if you chose an earlier from, and from on the bank feed shows that day.
A statement for an account the bank feed fills brings in only the days before the feed starts. Use one for history from before then.
Bring in a statement
Section titled “Bring in a statement”-
On the bank’s website, download the account’s activity as CSV, OFX or QFX (QFX is sometimes called the Quicken download). Venmo and PayPal statements download as CSV.
-
In Grouperly, open Finances → Accounts, pick the account, and choose Bank statements.
-
Under Bring in a statement, choose the file. It can be up to 5 MB.
-
For a CSV, check Which column is which: the date, the description, and either the amount or money in and money out. Add the check number and the balance if the file has them.
Grouperly guesses from the file’s headings, and remembers your choices for that account, so next month’s file just goes in.
-
Look at the first lines. Money in should show with a + and money out with a −. If they’re the wrong way round, tick This file shows money out as positive.
-
Choose Bring in (it says how many lines).
A statement goes into one of the group’s money accounts: checking, savings, the cash box, Venmo or PayPal. A card isn’t one yet.
Bring in as much as you like. A line already in is skipped, so a statement that overlaps last month’s is fine. Lines from before the books start are left out, because the opening balance already has them.
The file itself isn’t kept, only its lines.
Match or post each line
Section titled “Match or post each line”Whether a line came from the bank feed or a statement, Grouperly ticks off what the books already have, and marks it cleared:
- a check, by its number;
- a Stripe payout, a deposit, or a payment by direct deposit, by its amount within five days;
- otherwise, the only entry in the books for the same amount within four days.
Whatever’s left is in Finances → Accounts → Review, first, under From the bank. Each row has a one-click choice when it’s clear what the line is:
- Match Scout Shop · Oct 22 when exactly one entry in the books could be it;
- Post as Kroger · Events to put it in the books as Grouperly suggests: who it was, and their usual category, or where that name’s money went before.
When two or more lines have a suggestion, Post the suggested posts them all at once.
Open a line for the rest. The day, the account, what the bank says and the amount are fixed at the top. Then choose:
- Match, to say it’s one already in the books. Pick it; the nearest is first. Nothing new goes in the books;
- Post, to put it in the books with the same one-line form as an entry to review: who, the category, what it was for and a note, with who and the category already suggested and the bank’s words as the memo. Split gives a table of lines that must come to the bank’s amount, such as a deposit of several checks;
- Transfer, for money moved to or from another of the group’s accounts, such as savings;
- Leave it out, for a line the books shouldn’t have.
Whatever’s made from a line is cleared as it’s made. Matching runs again each time you open Review, so an entry you type in later is matched then.
Changed your mind? On Bank statements, choose Show every line. Unmatch puts a line back to match, and Put it back returns a line you left out. Removing an entry from the books puts its line back to match, too.
Where you see it
Section titled “Where you see it”- In the account’s register, an outlined C marks an entry cleared at the bank, and a filled R one that’s reconciled.
- In Finances → Overview, To review lists each account with lines to match or post, linked to Review.
Next, reconcile the account against the statement’s ending balance.
Who can do it
Section titled “Who can do it”Whoever keeps the group’s books: adults who handle its money, such as the treasurer. It’s part of Grouperly Plus.