Why Constat
Treasurers and bookkeepers spend month-end working out which gifts made up which bank deposit. Constat ties each payout to the deposit your bank received and posts it to QuickBooks Online once an approver says yes.
By hand, month-end means opening each giving payout, finding the bank deposit it became, and keying the funds and fees into QuickBooks. Each night we pull the new gifts, group them into the payouts your bank received, and check each one to the cent.
A payout that does not tie out is held with the difference shown, so whoever reconciles sees it before anything posts.
An entry per gift, or per day of gifts, does not line up with the bank when one payout carries several days of gifts, less fees. We post one deposit per payout, split by fund, for the amount the bank received.
When the deposit in QuickBooks is the deposit on the statement, reconciling the bank account is a match, not a search.
Nothing posts until someone with approver access approves it, or until an approver turns on auto-post for payouts that tie out exactly. The approver sees the gifts by fund, the fee and the net first.
Every QuickBooks entry is recorded before it is sent and carries its payout's reference, so a retry never creates a second deposit.
At month-end
Each payout is checked to the cent against the total its source states, or the deposit amount from your bank statement.
QuickBooks gets one deposit for each payout the bank received, with the gifts on the income account of each fund.
Each night we check that the deposits we posted are still in QuickBooks; one deleted there shows in your review queue.
Get started
Connect Planning Center and QuickBooks, map your funds, and review the payouts Constat finds. 30 days free, no card.
