DIY Bookkeeping Tools
Sales & Payout Reconciliation Workbooks
Do your own books? Your bank deposits are probably telling only part of the story. Each workbook walks you — or your in-house bookkeeper — through reconciling a platform's gross activity, fees, tips, refunds, and other adjustments to the deposits that reached your bank. Then it automatically calculates the journal entry for you to review and enter into your accounting system.
Point-of-Sale Workbooks
Toast Close Workbook
Restaurant-grade: gross sales, comps, tips payable, gift cards, fees, and chargebacks — mapped from Toast's own reports to one clean entry.
Coming SoonSquare Close Workbook
From the Square dashboard to a balanced entry: sales, refunds, instant-deposit fees, and loan withholding reconciled to actual bank deposits.
Coming SoonLightspeed Close Workbook
Turn Lightspeed report activity and the deposits received into a reconciled, review-ready month-end journal entry.
Coming SoonPayment & Delivery Workbooks
Stripe Close Workbook
Payouts that never match invoices, explained: gross charges, processing fees, refunds, disputes, and reserve holds — tied out monthly.
Coming SoonDoorDash Close Workbook
Turn DoorDash settlement activity and deductions into a reconciled journal entry tied to the deposits your business received.
Coming SoonUber Eats Close Workbook
Reconcile Uber Eats settlement activity to actual deposits and calculate a clean month-end journal entry for your books.
Coming SoonBundle Pricing
Choose Any Three
Choose any three reconciliation workbooks and save $98 compared with purchasing them separately. Includes 12 months of updates to the three selected workbooks.
Coming SoonComplete Workbook Collection
Get all six workbooks and save $295. Includes updates to those workbooks and any new reconciliation workbooks released during the 12 months following purchase.
Coming SoonFor Bookkeeping & Accounting Firms
Bring Pono tools into your client work
Every standard workbook and bundle purchase is licensed for use by one legal entity. If your firm wants to use Pono Ledger workbooks across multiple client files, ask us about a separately priced multi-client firm license.
See It Before You Buy
Watch the one-minute workbook overview
A quick tour of exactly what's inside — the report walkthrough, the color-coded inputs, the entry that builds itself, and the tie-out that must match your bank. Because these are digital downloads, we'd rather you see the workbook before you buy it than wonder afterward.
The Hawaiʻi problem no mainland template covers
If your books record only net deposits, gross receipts may be understated and processor fees or other deductions may be recorded incorrectly — and that can produce inaccurate GET reporting that surfaces at the worst possible time. Each workbook begins with gross activity, then separately accounts for fees, refunds, tips, liabilities, and other adjustments — the way Hawaiʻi's gross-receipts system demands. That's the difference between a workbook written here and one written anywhere else.
What's inside every workbook
- Plain-English walkthrough: exactly which reports to run in your POS, by name
- Guided mapping — gross sales, discounts, refunds, tips payable, gift-card liability, GET visibly passed on or sales tax collected (as applicable), merchant fees, chargebacks, net deposits
- The JE builder — color-coded input cells that assemble your month-end entry automatically
- Self-checking tie-out — if your entry doesn't net to your actual bank deposits, the variance cell tells you
- A review-ready journal entry calculated from your inputs for manual entry into your accounting system
- A fully worked example month, so you see the destination before you start
- 12 months of updates — when a platform changes its reports, we email you the new version
- PDF quick-start companion
Questions, answered plainly
Which accounting software does it work with?
Any accounting system that allows you to enter a journal entry manually. The workbook is a standalone Excel tool: it reconciles the platform reports to deposits and calculates the journal entry, but it does not connect to, import into, or post anything to your accounting software.
Can Pono Ledger take over my monthly books in Xero?
Our managed monthly bookkeeping service is provided in QuickBooks Online through the secure Pono Ledger portal. If your current books are in Xero, QuickBooks Desktop, or another system, we will review and scope the conversion to QuickBooks Online before ongoing service begins. You may still use the DIY workbooks with your current accounting system because you enter the calculated journal entry manually.
What are the technical requirements?
Each workbook is a standard Excel file (.xlsx) with no macros — it works in Excel for Windows and Mac (2016 or later), Excel Online, and imports into Google Sheets. Formula cells are protected; you only type in the color-coded input cells.
How is it delivered?
Automatically, by email, immediately after successful payment — along with the quick-start PDF. Check your spam folder if you don't see it, and if anything goes wrong, write aloha@ponoledgerhawaii.com and we'll re-deliver.
Can I use one workbook for several businesses or locations?
One purchase covers one legal entity — all of its locations, and use by its employees or its contracted bookkeeper. Each additional entity needs its own copy. Bookkeeping and accounting firms that want to use the workbooks across multiple client files may request a separately priced multi-client firm license.
Is support included?
Email support for workbook functionality is included — if a formula or instruction isn't working, write us at aloha@ponoledgerhawaii.com and we'll reply within one Hawaiʻi business day. Support does not include reviewing your completed entries, bookkeeping for you, or tax advice — if you want professional eyes on your books, that's our monthly service.
What's your refund policy?
Because the workbooks are downloadable digital products, purchases are final once download access is provided — the one-minute overview video above shows you exactly what you're buying before you commit. If your workbook isn't delivered, is materially defective, or materially differs from its description, contact us within 14 days: we'll correct or replace it first, and if we can't cure a verified problem within 10 business days, we'll refund the purchase price. Duplicate charges are always refunded. Full policy in our Terms of Service.
What about updates when my platform changes its reports?
Platform report formats drift. Your purchase includes 12 months of updates from the purchase date — we email you the new version when a platform changes.
How does the $199 service credit work?
A workbook purchaser may apply up to $199 of the purchase price toward the first month of ongoing monthly bookkeeping for the same business, if the engagement begins within 90 days of purchase. One credit per business — this applies to both bundles too ($199 maximum credit). Not redeemable for cash or combinable with other offers.
My platform isn't listed.
Tell us what you use through the contact form. Customer demand helps determine which reconciliation workbook we build next.
License: one purchase permits use by one legal entity and its employees or contracted bookkeeper. It may not be used for unrelated businesses, resold, shared publicly, or incorporated into another commercial product. Independence: Pono Ledger Hawaiʻi is not affiliated with, endorsed by, or sponsored by Toast, Square, Lightspeed, Stripe, DoorDash, Uber Eats, Intuit QuickBooks, or Xero; product names and trademarks belong to their respective owners. The workbooks assist you in organizing information and preparing potential accounting entries — you remain responsible for the completeness and accuracy of inputs, for determining whether an entry is appropriate, and for reviewing results before posting. See our Terms of Service and Privacy Policy.