Keeping the books
Grouperly keeps the group’s books like a checkbook: the accounts where its money sits, money in and money out, and what each was for. Grouperly keeps the arithmetic straight behind the scenes. You never need to know a debit from a credit.
Every group’s books are kept, on every plan. Grouperly starts them by itself, and what goes through Grouperly goes into them by itself: payments, refunds, cash and checks, reimbursements and bills. So a group that only handles cash, or has no bank account at all, still has a record.
Grouperly Plus adds what’s built on the books: linking a bank and its statements, reconciling and closing a month, budgets, reports and the export for your accountant, moving from QuickBooks, Finances, and members’ credit.
How your books start
Section titled “How your books start”Grouperly starts your group’s books the first time they’re needed: when money first goes through Grouperly, or when someone opens Finances → Accounts. Nothing is asked first.
- The accounts: a Cash box, and a Bank account if the group takes card payments, so its payouts land somewhere. Rename the bank, and add the others the group keeps (Savings, Venmo, a card), in Finances → Settings → Accounts.
- When they start: the day the group was made, so everything that went through Grouperly since is in them.
- What was posted for the time before Grouperly started them comes in already confirmed, so you don’t start with a year to look through.
- Change where they start, and what each account held then, in Finances → Settings.
- The year: your template’s. A Scouting unit’s starts in September. Change it, or the time zone, in Finances → Settings.
For its first month, Finances → Accounts says when Grouperly started the books.
Only the bank’s name and the last four digits are kept. Grouperly never asks for account or routing numbers.
Categories come from your group’s template: a short list in plain words, such as Dues, Events and Fundraising for money in, and Events, Supplies & equipment and Registration & insurance for money out. Add your own later.
Events aren’t categories. There’s one Events category each way, and each entry says which event it was for. The reports break Events down by event.
The same goes for roles, subgroups and storefronts: money for the Quartermaster, the Wolf den or the Trading post goes on a Roles, Subgroups or Store costs category (money in for a storefront goes on Store sales), and each entry says which one. Each of those categories is added the first time you choose one, so your list only grows by what you use.
Kinds of event cost: put categories under Events in Finances → Settings, such as Events › Food, Events › Transportation and Events › Registrations. Choose one with the event, and the event’s report still counts it all.
Enter money in or out
Section titled “Enter money in or out”- In Finances → Accounts, pick the account.
- Choose + Money in, + Money out or Transfer.
- Fill in the top line: the date, the account, and a check number if there is one.
- Fill in the line below it, one box per column:
- Paid to (or From): start typing to pick someone on the roster or in Contacts, or type any name. The end of the box says whose it is: Roster, Contact, or Not linked for a name you typed. Not there yet? Add them from the box;
- Category and For: start typing in each and pick one.
- For is an event (or a recurring event as a whole, such as a Pinewood Derby track), a role, a subgroup or a storefront, or Nothing in particular. Events near the entry’s date come first, and typing a month or a year finds older ones.
- Category: pick an event first, and Events and the categories under it come first (Events › Food). Left as it is, it’s that one’s own category (Events, Roles…);
- Note, if you like: a few words on what that line was for;
- Amount.
- Under the line, Memo is for the whole entry (the ⓘ beside it says so), and Files takes receipts or an invoice: photos, PDFs or Word files, up to ten. Photos lose the location your phone saved. Anyone who sees the books can open them.
- Choose Save.
One check for several things? Choose + Split it across another line. Each line has its own category, what it was for, note and amount: for example, $250 for Events and $50 for Supplies. The table says the total.
A deposit of several checks? Split it, a line for each check, and put who each one was from in its From box. A new line starts with the name above it, so change it for each check. The row then names them, Jordan Kim, Sam Lee +1, and says Split · 3 parts. When every line names the same person, that’s who the whole entry was from.
Food for the campout, under Supplies? Choose the campout under For and Supplies (or Events › Food) under Category. The event’s report still counts it.
A transfer moves money between two of the group’s accounts, such as a cash deposit from the cash box to Checking.
Each account’s Register shows its entries newest first, as a checkbook does: the date, the check number, the payee, its category (or Split · 3 parts), money out, money in, and the balance after each. An outlined C means it cleared at the bank and a filled R means it’s reconciled. A dot by the payee means it’s still to review: it’s in Review.
Someone new in the name box
Section titled “Someone new in the name box”An old entry may name a member who’s no longer on the roster, and a new one a store the group hasn’t bought from before. Add them right from Paid to (or From), wherever you enter or review money: the register, Review, and the bank’s lines.
- Type their name.
- At the foot of the list, choose Add “…”. It says not found when nothing matched, or not one of these under the names that did.
- Choose A member or A contact.
- A member is someone in the group, now or in the past. Fill in their First name and Last name (split from what you typed), their Status, and their email and phone if you have them.
- Active: in the group now.
- Alumni: in the group before, kept with their history and off the everyday list. Say Why they left if you like.
- For an entry over a year old, it starts on Alumni.
- A contact is a business, organization or person the group works with, such as a store, a campsite or a donor. Choose An organisation or A person, then its Name, its Usual category (their entries start in it, here and on bills, and it fills in this line’s category if it has none), and its email and phone if you have them.
- A member is someone in the group, now or in the past. Fill in their First name and Last name (split from what you typed), their Status, and their email and phone if you have them.
- Choose Add member or Add contact.
They’re picked on that line at once, and every other name box on the page finds them. When the list finds one of the alumni, it says alumni · on the roster.
- No invitation goes out to a member added this way. Invite them from People when they should sign in.
- A contact is the group’s, as every contact is. Add more about them, and private notes, in Contacts.
- Already there? A contact with the same name isn’t added twice: pick them from the list, or bring an archived one back from Contacts. An email someone on the roster already has is refused too.
- Who: whoever keeps the books can add a member if they can also add people to the roster, and a contact if they also manage the group’s contacts. A choice they can’t make is greyed out, and says who can.
Change or remove an entry
Section titled “Change or remove an entry”In the Register, click an entry’s row and it opens right under it, on a computer or a phone. Click it again, or Close, to fold it away. It’s the same form as entering one: the date, account and check number, its lines as a table, the memo and files. Under History is every change made to it: who, and when.
An entry typed in or brought in from QuickBooks changes right there:
- change any box, then choose Save changes (Save and confirm for one to review). Nothing is saved until you do. If someone else changed it since you opened it, you’re asked to open it again;
- Confirm as it was confirms one to review without what you changed in the boxes;
- Remove… takes it out of the books. What it was stays in its history.
On a phone, each entry is a card: who and the amount, then the day, its category, the balance after it, and C or R.
Nothing is changed silently.
See one person’s, a category’s or an event’s entries
Section titled “See one person’s, a category’s or an event’s entries”Under Find, the Register has three boxes: Who, Category and For. Type a few letters and pick from the list. On a phone, they’re under Filters.
- Who: someone on the roster or one of the group’s contacts. It finds entries paid to or from them, and entries where a line names them, such as their check in a deposit. Only entries linked to them count, the ones marked On the roster or In Contacts. A name that was only typed is found with Find.
- Category: a category with entries on it. One with others under it includes those.
- For: an event, a recurring event, a role, a subgroup or a storefront.
A line says what that comes to, such as “12 entries for Jordan Kim: $840.00 in · $1,203.50 out”.
- A deposit of several checks counts in full for each person it names.
- The register shows one account at a time, so the line also says how many match in your other accounts, each a link. Switching account keeps what you chose.
- The balance after each row is still the whole account’s.
Download these as CSV downloads only what’s shown, narrowed by Find’s words too. The × beside a box clears it, and Clear filters clears all three.
Put a year of entries right
Section titled “Put a year of entries right”After moving from QuickBooks, every entry needs the right category, what it was for and who it was. Work through them in Finances → Accounts → Review, the tab beside Register. It’s there for whoever keeps the books, with how many are waiting.
Do this before you close any months. Once the books are closed through a day, what each entry was for can’t change.
Review lists:
- To review: imported entries nobody has looked at yet, and ones Grouperly posted itself (New). With Grouperly Plus, the bank’s lines to match or post come first;
- or Needs a category: anything still on Uncategorized;
- Find looks through who it was (and who each line was from), memos and notes, categories, events, roles, subgroups and storefronts, check numbers, and amounts (type 120.00 or $120).
What each row shows: who, and what it says to categorize it from: each line’s note (from QuickBooks, its Memo/Description, which usually says what the money was really for), and the check number. Then its category, what it was for (for… when nothing), and the amount.
Change one right on the row: click the category or what it was for, start typing, and pick. That saves it and confirms it, and the other one stays as it is. An entry split into several parts says Split · 2 parts (or however many), and opens instead.
Open one by clicking its row. The date, account, check and amount are fixed at the top, with why it was suggested and the category it came in on (It came in as Campouts). Below them is one line of boxes: Paid to, Category, For and Note, then the Memo and Files. Someone it names who isn’t in Grouperly yet can be added from the box.
- Confirm saves anything you changed and confirms it: it’s already in the books, and this says it’s right. The next one opens, so you can work down the list. Pressing Enter in the last box does the same.
- Split gives a table of lines on the entry’s amount, which can’t change here. It says what’s left to split, and Confirm waits until nothing is.
- ✨ Suggest auto-categorizes this one. Open in the register shows it there, and Remove… takes it out.
Change many at once: tick the rows (or the box at the top for every row shown), then:
- pick Their category, What they were for, or both, in the boxes that appear. Each keeps the other as it has it, except an entry on plain Events (or Roles…), which moves to its new one’s category. Money in and money out can be picked together;
- or choose Confirm for the ones that are already right.
Picking what a row already is also confirms it, so it’s a quick way to say “this one’s fine”.
Auto-categorize
Section titled “Auto-categorize”Auto-categorize does most of the sorting for you, then you check it.
- Fix a handful by hand first. It learns from what you’ve confirmed: “everything from Scout Shop is Awards”, “QuickBooks’ Den expenses is now Supplies”.
- In Review, choose ✨ Auto-categorize all … above the list (it goes through every page of what the list shows, such as To review). You can also tick some rows and choose ✨ Auto-categorize, or open one and choose ✨ Suggest. What a run did shows at the foot of the window, with Undo.
- Each entry it changes is marked Suggested and says why, for example Like 6 reviewed ones from the same payee or Its words name Fall Campout, the event 10 days from it. Open one to see the reason in full.
- Check them: Confirm the good ones (tick several at once), and fix the rest on the row.
What it looks at:
- who: a payee’s name matched to someone on the roster or in Contacts, only when exactly one person or contact matches;
- what it was for: an event its note names, near its date (so last year’s check goes to last year’s campout); a subgroup, role or storefront it names; or what the same payee’s reviewed entries were for;
- the category: what you chose for the same payee, or for the same old QuickBooks category, the contact’s usual category, or a category its note names.
What it can’t place is left as it was. It never confirms anything on its own.
Undo auto-categorize puts the whole run back, except entries you’ve changed or confirmed since.
With AI. On a plan with AI credits, auto-categorize asks AI about what its own rules couldn’t place. These come in as Suggested by AI. Before anything is sent:
- everyone on the roster, and the group’s own name, are replaced;
- any other names are found and replaced too;
- an entry that still names someone isn’t sent at all.
The AI only sees the entry’s date, amount, the words in its notes, and your list of categories, events, roles, subgroups and storefronts. Each request uses a little of the group’s AI credits. Settings → Photos & assistant shows how many this month, and turning off the group’s assistant there turns this off too.
Reports
Section titled “Reports”Finances → Reports shows three reports for the dates you pick: this year or last year (the group’s own year), this month or last month, or two dates of your own. Choose the dates, then Show.
- Money in and out: what came in and went out in each category, counted on the day the money moved. Open Events to see each event’s part, and a category to see the ones under it. The bottom line is the net, with any offsets under it.
- What the group has: on the last of those dates, what each account held, minus anything the group holds for others (such as members’ credit). The group’s own money is shown as where the books started plus money in less money out since, so you can see it adds up.
- By event: each event’s money in, money out and net, across every category. A recurring event’s own costs, such as a Pinewood Derby track, show as one line.
- By role, By subgroup and By storefront: the same for each role, subgroup and storefront with money in those dates. They show only when there’s some.
In Money in and out, the Roles, Subgroups and Store categories open into each one, as Events does.
With Grouperly Plus, Reports also has:
- Owed: what’s owed to the group (event payments, dues, store orders, fundraiser pre-orders, and fundraiser checks that came back) and what the group owes (reimbursements, bills, credit to pay out, consignment sellers, and Grouperly). Each kind opens into who, what for, and since when, or a bill’s due date. It’s as of today, whatever the dates, because the books count money when it moves. Finances → Overview shows the two totals.
- The treasurer’s report, for the committee meeting: choose the month, then PDF or CSV. It has the month and the year to date by category, the year’s offsets, what the group has at the month’s end, what’s owed, the year’s events, roles, subgroups and storefronts, and how the books are doing. A month that isn’t over runs to today.
- By recurring event: each recurring event’s events side by side since the books started, so this year’s campout sits beside last year’s.
- The year-end: gross receipts for the IRS’s 990-N, and who gave. See The year-end.
Each report has Download CSV for a spreadsheet. In Finances → Accounts, Download CSV gives an account’s whole register, oldest first, with the balance after each entry. The CSVs are on every plan.
For your accountant
Section titled “For your accountant”With Grouperly Plus, Download for your accountant gives one ZIP of the books for those dates, in the form an accountant, a tax preparer or your chartered organization’s treasurer expects:
- journal.csv: every entry, line by line, with debits and credits and the account codes;
- trial-balance.csv: each account’s balance;
- chart-of-accounts.csv: the accounts and categories with their codes;
- the three reports as CSVs;
- quickbooks-online.csv: the same entries laid out for QuickBooks Online’s journal entry import;
- README.txt: what each file is.
There’s no Xero file, because Xero’s journal import can’t post to a bank account. An accountant on Xero can work from the journal.
Offsets
Section titled “Offsets”Some money comes in only to go back out: dues collected, then the council’s registration paid; apparel sold, then apparel bought. In Money in and out the two are far apart, so the group can look as if it spends a lot on things it mostly passes through. An offset puts a money-in category and a money-out category side by side, with the net, so you see where the money really goes.
Set one up:
- Open Finances → Settings, and find the category under Categories: money in or Categories: money out.
- Choose Edit, then under Offset pick the category of the other kind, such as Registration & insurance for Dues.
- Choose Save.
Both categories now say offset with the other. Offsets are optional: most categories don’t need one.
- Several on one side: to put Registration and Awards against Dues, give each of them Dues as its offset.
- Take one out: choose None. An offset left with only money in, or only money out, ends.
- A category and the one it’s under can’t both be in an offset, because the one above already counts the ones under it. Uncategorized can’t be in one.
Read it:
- In Finances → Reports, Money in and out has Offsets under the net: each offset’s money in, money out and net. Below zero, in red, the group paid the difference.
- Each category in an offset says so in its own row, with the net, so you don’t have to look for the other half.
- The report’s CSV, Finances and the treasurer’s report show them too.
The totals above the offsets still count every category, as an accountant and the IRS read them. An offset only adds the side-by-side view.
The books keep themselves
Section titled “The books keep themselves”Grouperly already records the group’s money: payments for events and the store, fundraisers, refunds, cash and checks and their deposits, reimbursements, and members’ credit. Each of those goes into the books by itself, on every plan, so nobody types it in twice. Each entry says which record it came from.
-
Card payments go into the Stripe account, less the processing fee, which goes to Processing fees. Each person paid for counts toward the event.
-
Stripe payouts move money from Stripe to the bank on the day it arrives. A payout that fails afterwards comes back out.
-
Cash and checks wait in Not yet deposited until they’re deposited. In Finances → Cash & checks, Mark deposited… asks which account they went into.
-
Venmo, Zelle and other payments recorded by hand go into the account set for each in Finances → Settings, under Where money recorded by hand lands. Venmo and Zelle are offered once the group has them: see Payment methods.
-
Refunds come out of where the money went back: Stripe for a card, cash still waiting to be deposited, or the account set for how it was given back.
-
Members’ credit is money the group owes its members. Credit added, reimbursements paid as credit, and payments made with credit move it.
-
Reimbursements and bills paid come out of the account they were paid from, on their category: the one chosen, else Events, Roles, Subgroups or Store costs for what they were for, else Uncategorized. Each counts for its event, role, subgroup or storefront. A direct deposit’s fee goes to Processing fees.
-
Store orders count as Store sales, line by line, for their storefront, or for the event when it’s an event’s storefront. Older orders may not name their storefront: to add it, Find “Store order” in Accounts, tick them, and pick the storefront.
-
Card disputes come out of Stripe once Grouperly takes back what they cost.
-
Fundraisers: each sale goes in on its own, on the fundraiser’s event:
- cash and checks wait in Not yet deposited until they’re deposited;
- a card on another reader, such as Square, goes into the account set for Paid another way (Square’s own fees aren’t recorded);
- a card on the buyer’s phone goes into Stripe, less the processing fee.
A consignment seller’s share waits in Owed to consignment sellers until they’re paid, and the rest counts as Fundraising. Refunds, sellers’ payouts, what a paid seller pays back, a cash drawer over or short, a returned check, and Grouperly’s fee invoice once it’s paid go in too. A practice fundraiser never does.
The books catch up when you open Finances → Accounts or Reports, and every ten minutes. Payments in Stripe’s test mode never go in.
Who each entry is from. Grouperly links these entries to the people on your roster, so the register can show one person’s:
- On the entry: whoever paid an event’s fee, dues or a store order, whose credit it is, and the seller a fundraiser paid.
- On a line: who an event’s fee or the dues were for, when that isn’t whoever paid. So a parent’s payment is found under the parent, and their child’s fee under the child.
- Someone who isn’t on the roster, such as a guest with no account, stays a name.
- Older entries are linked the same way. No amount, date or category changes, and each entry’s History shows it. A name you chose yourself is left as it is.
The nightly check. Every night Grouperly reads all those records again and adds anything it missed. Then it checks four of its own accounts against its records: Not yet deposited, Members’ credit, Owed to consignment sellers and Stripe. If one doesn’t match, Finances → Accounts says which, with both amounts. If it still doesn’t match the next night, the group’s owners and admins get an email.
Before the books start. What those records left in Stripe and Grouperly’s other accounts (such as cash not yet deposited, or credit members hold) becomes one entry the day before the books start: Opening balances from Grouperly’s records.
When a record changes. If a record changes after it’s in the books, such as a deposit undone or a payout voided, Grouperly adds an entry for the difference, dated the day it found the change. It’s marked New, so you see it.
Review what Grouperly posted
Section titled “Review what Grouperly posted”Each entry Grouperly makes comes in marked New, in Finances → Accounts → Review. The ones for the time before Grouperly started your books come in already confirmed. Open one, and change what each part was for if you need to: put a part under a different category or event, add a memo, or split it across categories (the splits must add up to the part). Then choose Confirm.
A check or direct deposit that paid people back has a part for each reimbursement or bill it paid. Each part is its own card, headed by its request and amount, like Request 12 · Fall campout · Tarps (receipt) $30.00, with its categories under it. The request’s number links to it. If you approve expenses or handle the money, its receipts are there too, as receipt or receipt 1, receipt 2, so you can see what to split it by.
In the Register, the same entry has Confirm and Change what it was for.
The amount, the date and the accounts the money moved through come from Grouperly’s record. To change those, change the record: refund the payment, or undo the deposit.
Your changes stick. A refund comes off the category you moved its payment to, not the one Grouperly first chose. The same goes for a returned check, credit taken back, and a fundraiser’s refund.
Finances → Overview: what’s waiting
Section titled “Finances → Overview: what’s waiting”With Grouperly Plus, Finances → Overview starts with how the books are doing, then To review.
How the books are doing is the same for everyone who sees the books. People who only see them find it on Finances → Accounts. It shows:
- waiting for review: how many things, and how long the oldest has waited;
- not yet deposited: cash and checks, how long the oldest has been held, and who holds the most;
- the nightly check: whether everything matched, and when it last ran;
- reconciled: how far each bank account is reconciled.
To review lists, oldest first, what’s waiting for you:
- reimbursements waiting for your approval, with Approve right there, and those approved and waiting to be paid;
- your cash and checks to deposit, and anyone holding some to hand in;
- payments families say they paid another way, to confirm;
- Grouperly’s new entries, a line for each kind of record and event (“14 payments for Spring campout”), with Confirm all;
- lines from a bank statement to match or post, in Review;
- an account to reconcile once a month has ended;
- any account the nightly check found apart.
Beside it are each account’s balance, what the group holds for others, what’s owed both ways, and money in and out for the year so far. The payments list is below, under Payments.
The daily digest. Once a day, after 8 in the morning in the books’ time zone, everyone who handles the money gets an email with what’s waiting for them, but only when something is. Turn it off under The Books’ Daily Digest in your notification settings.
If an account is hidden. When someone hides an account money sits in, such as Checking, the group’s owners and admins get an email saying who did it.
Settings
Section titled “Settings”Finances → Settings has:
- the books’ year: the month it starts, and the time zone;
- where the books start: the day, and what each account held then;
- accounts: add, rename, change a bank’s details, or hide one you no longer use. An account with money in it stays until the money’s moved;
- payment methods: see below;
- where money recorded by hand lands: the account cash, checks, Venmo, Zelle and other payments go into, and where deposits go when Mark deposited… doesn’t say. Each one is worked out from your accounts until you choose;
- members’ credit (Grouperly Plus): on or off. See Member credit;
- categories: add your own, rename them, put one under another (one level), give one an offset, choose who’s Responsible for one, hide one, merge one into another, or delete one nothing uses. Responsible is a role or a person, such as a Quartermaster for Equipment: they can approve its reimbursements first and see it against the budget on their role’s Finances tab (see A category’s responsible); a category under another with nobody of its own takes its parent’s. Untick On reimbursements on a money-out category to keep it off the list members choose from when they ask to be paid back; you and bills still see it. Merging moves its entries and notes it in each one’s history, and the category merged away leaves its offset. Delete shows on a category with nothing in the books on it and no category under it. One that’s in a budget, or that a bill or reimbursement is on, stays too: hide it or merge it instead. A category merged away has nothing left on it, so you can delete it afterwards;
- closing the books (Grouperly Plus): see Reconcile and close the books;
- who sees Finances (Grouperly Plus), the summary of the books the group shares: see Finances.
Payment methods
Section titled “Payment methods”Finances → Settings → Accounts starts with the ways a payment recorded by hand can say it was made, whether you’re paying someone back or recording money in:
- Cash, Check and Another way, always;
- Venmo, once the group has a Venmo or PayPal account. Choose + Add Venmo to add one;
- Zelle, once you say which account Zelle money lands in. Choose + Use Zelle to have it land in the bank, or Stop to take it away.
Paying someone back offers just these. Its Manage payment methods link comes here.
Moving from QuickBooks Online
Section titled “Moving from QuickBooks Online”If the group kept its books in QuickBooks Online, bring them over instead of typing them in. It’s part of Grouperly Plus.
- Set the books up first, starting on the day you want them to start, usually the first day of the group’s year.
- In QuickBooks Online, open Reports, find Account List, and export it to Excel or CSV.
- Open the Journal report, set the dates to All Dates, choose Run report, and export it the same way.
- If you can, export the Vendor Contact List and the Customer Contact List from Reports the same way. They’re optional: with them, what QuickBooks knows of who you paid and who paid you comes over too.
- In Grouperly, open Finances → Settings, then Bring them in from QuickBooks. Add the files and choose Read the files.
Nothing comes in until you’ve seen what will:
-
Where their accounts go: each QuickBooks account goes on one of the group’s accounts or categories, or a new one by the same name. QuickBooks’ long list can fold into the group’s few: put several on one. Choose Show what that changes after changing any.
-
For the event: QuickBooks needs an account for each event, such as Summer Camp 2025 Income and Summer Camp 2025 Expenses. In Grouperly they go on Events, and each line is tied to the event itself. Under an account that goes on a category, choose:
- an event on the group’s calendar;
- a recurring event, such as Summer Camp: each line goes on that year’s;
- Add a past event, for one held before the group used Grouperly. It goes on the calendar as an event already held, with no RSVPs, and nobody is told. Change its name or day under Past events to add;
- Not for an event.
Grouperly suggests these from the account’s name and year.
-
Who they are: each name in QuickBooks, from the Journal and the contact lists, can be someone on the group’s roster or one of its contacts, so each entry says who it was paid to or from. Grouperly suggests who by email, then by name, and never guesses between two people with the same name. For each, choose:
- someone on the roster or in Contacts: choose Someone else… and type their name;
- New contact, an organization or a person: it gets the email, phone, website and address QuickBooks has, who to ask for, your account number with them, and the category most of their money was on;
- Add to the roster, as inactive (on the roster and in its history, but not a member, as most old records are) or as active. Either way, nobody is invited; invite them from the roster when you want them in;
- Just the name.
Every name not matched turns all the vendors into contacts, puts all the customers on the roster, or keeps just the names, in one go. A contact the group already has gets what QuickBooks knew that it was missing; nothing it has is changed, and nobody on the roster is changed. Adding contacts needs Manage contacts, and adding to the roster needs permission to add members.
-
Opening balances: everything before the day the books start makes up what each account held then. Choose QuickBooks’ balances or keep the ones typed in Grouperly. An account QuickBooks doesn’t have, such as a cash box, keeps its typed balance.
-
May already be in the books: a transaction that matches an entry already here (the same account and amount within three days) stays out unless you tick it.
Then choose Bring them in. Each transaction since the books started becomes an entry you can change like any other, marked To review. Bringing in the same files again adds only what’s new, and Grouperly remembers where each account went and who each name is. Next, put them right.
A deposit of several checks. QuickBooks names who each line of a deposit was from. A transaction naming several people comes in with no payee, and a part for each one saying who it was from: someone on the roster or a contact, as you matched the name, or else the name. One naming one person comes in with that person as the payee, as before.
Brought them in before? Bring the same files in again. Each entry already in gets who each of its parts was from, where a part doesn’t say yet:
- a part that came in as several checks added together (three on Popcorn sales) is split back into the checks, each keeping the category you’ve given the part since;
- the payee it took from the first name comes off, since each part says who;
- an entry you’ve changed since, so its parts don’t add up as QuickBooks says, is left as it is;
- in a closed month, parts are named but never split.
Before you choose Bring them in, it says how many entries it will give who each part was from.
Invoices and bills. Grouperly counts money when it moves, so there are no accounts receivable or payable to set up. What’s owed to the group is its RSVPs still to pay; what it owes is its bills and reimbursements. So:
- an invoice or a bill from QuickBooks doesn’t come in, since no money moved;
- its payment does, on the day it was paid, on what the invoice or bill was for. Grouperly matches a payment to an invoice by the name on both: one for the same amount first, then the oldest;
- Invoices and bills on the same page lists any still open when the Journal ends. When one is paid, record it in Finances → Accounts;
- it also lists any payment no invoice matched. Those go where you put QuickBooks’ A/R or A/P account.
Undo. If it didn’t come out right, choose Undo it on the same page. The entries it brought in go, except any changed since. Accounts, categories, past events, contacts and roster entries it made, and the opening balances, stay; change them in Finances → Settings, on the calendar, in Contacts and on the roster. To bring the same files in again with different choices, undo first: what’s already in isn’t brought in twice.
Who can see and change the books
Section titled “Who can see and change the books”- Change them: adults who handle the group’s money: owners, admins, and anyone given the group’s money or a role carrying it, such as Treasurer.
- See them, read-only: anyone given a role carrying See the books, such as a Committee Chair or the two adults who review the books each year. They get Finances in the group’s menu, showing the books’ tabs only.
To give a role See the books, open People → Org chart → Roles, choose the role, open its Settings, and tick it under what the role can do.
On an event’s, role’s, subgroup’s or storefront’s own page, Money in the books shows its money in, money out and net, by category, and its latest entries.
- Whoever sees the books sees every entry, and Find it in Accounts.
- Its own people see their own one, as Finances shows money: totals, and who was paid on spending, but never who paid in, and a young person’s reimbursement isn’t named. That’s the role’s holders, the subgroup’s leaders, the storefront’s managers, and the event’s Organizers and Leads.
- Anyone else doesn’t see it, and it isn’t there when there’s no money for it.