ZAP's Bookkeeping Module

At ZAP Accounting Software we offer a suite of bookkeeping and accounting "software solutions" in modules which are functionally similar to but operationally very different from Intuit and all other minor Accounting Software players.

Our "software modules" are stand alone Google Sheet Templates. You make copies of them for free and use them in the privacy of your own Google Drive for the most private cloud based bookkeeping solution possible. This is paradigm busting news and a bit hard on Silicon Valley too.

We are the only major vendor to come to market with stand along spreadsheet templates as opposed to lesser desirable database solutions.

We are the only major vendor to offer a Spreadsheet Template Based Bookkeeping Solution with a fully integrated and dynamic Balance Sheet.

We are the only major vendor that designed our software to enable users to enter positive and negative values on the front end as opposed to the dogma of debits and credits, an unnecessary encumbrance for data entry.

We are the only major vendor who created a 6 Box Model for Accounting Systems to help all levels of users understand their own needs, our offerings and those of others in a more transparent fashion.

What we have to offer is so unique, it's off the mental reservation for most right now, at a cost that can't be beat.

Our Templates are FREE to all for LIFE because we work for tips.

The diagram below is a side by side comparison of our Bookkeeping Module and Intuit's Quickbooks.

Seeing is Believing.
Click here to view the Bookkeeping Template
It'll happen so quick you won't have time to think.
Don't forget to come back and read the rest!!

Databases have never been the correct solution for Bookkeeping and Accounting.

It's about technical issues that most without programming background have misunderstood for decades.


Try to save a bunch of numbers with decimal points in a database and see what problems arise.

Try to make copies of data in different places and see how problematic things can become.


Spreadsheets do NOT have any of these programmatic issues. They do present other challenges, but when all things are considered, they are the right tool for the right job, and always will be.

Everything that was done in this Spreadsheet Template Solution could have been done in the early 1990's. The problem? There was no money it . How many other digital solutions are we consuming today that really have been the second best thing sitting in plain view for over 30 years...

Welcome to a New Age in Small Business Accounting
The Age of Balance Sheet Understanding has Now Commenced!!

You're a CPA.

You've been in this game a LONG TIME.
For some, this simply can't be true. If it was it would have been done a long time ago.
For a small group of others, it's something they've kept a secret for a very long time. Devilishly.

Below, we provide you with a very quick run down of the Process and Data Flow of this Bookkeeping Module.

In it you will see the technical simplicity of this unfold along with a few key queries. May you be instantly converted you into a Believer too.

The Four Step Bookkeeping Process Ends with the Balance Sheet!

As a CPA, you know that the Bookkeeping for Tax Accounting is a simple 4 STEP PROCESS:

  1. Record Transactions "Accurately"

  2. Categorize Transactions

  3. Review the Income Statement

  4. Review the Balance Sheet

The End Goal of all proper bookkeeping is a Balance Sheet. Without it, nothing verifiable has truly been achieved.

The Balance Sheet has been the Small Business Person's Digital Nemesis since the Digital Age took flight.

No one wanted to do Accounting the old fashioned way, yet no one figured out how to do it in spreadsheets in order to exclude databases from Digital fray? Oy vey. That created an opacity that was impossible to see thru clearly for sure. Until now anyway...

Meet Our Balance Sheet...

We take a slightly different approach to the Balance Sheet.

There are no "sub reports" related to equity or Net Income. All of those values are represented directly on the Incremental Portion of the Balance Sheet for Transparency.

That information is presented on the top half along with the start date and end date which is required for that block of information.

This Report has an on/off button too. As long as it is "on", changes in a Journal are reflected here immediately.

Stepping through a Balance Sheet with an imbalance one day at a time to find errors is now child's play.

Full Data Flow is Easy to Follow

Asset and Liability Journals feed into a transaction aggregator where the signed values for both sides of the transaction are created. The Transaction Aggregator and the General Journal feed the General Ledger. The General Ledger Feeds the Balance Sheet. It's just that simple.

This is the same image as above with generic blocks replaced with screen grabs.

Asset and Liability Journals

Our Asset and Liability Journals use positive and negative values. That removes the unnecessary dogma for novice and intermediate users. This can be converted into a version with debits and credits on the input side in about 20 minutes. We'll likely have a standard release on that later, but for now, positive and negative values are the place to be.

General Journal

The General Journal is a double entry Journal. This is positive and negative values to go along with that theme. No need to worry about sign errors. They are flagged by the Balance Sheet and discovered easily.

The Transaction Aggregator

The Transaction Aggregator aggregates Asset and Liability journal entries.

The primary "query" that creates the Transaction Aggregator is a spreadsheet version of a SQL UNION query.

As more Journals are added, one line needs to be added for each new journal. It takes about 5 seconds to do and is copy and paste.

The far right side of the Transaction Aggregator worksheet creates the properly signed value for the other half of one line journal entries.

The General Ledger

The General Ledger has no transactions in it. It is just a view of Transaction Aggregator data joined with the General Journal (its another spreadsheet version of a SQL UNION query). Debits and Credits can be seen in the General Ledger. They can also be turned on and off to see what (if any) affects not having debits and credits in software has on the software. (hint -- none). It only disables a ledger integrity cross check report.

The dark red cell in column A contains this fancy formula below. In database terms this is a complex UNION query joining three sets of comparable data and sorting them to create the view that is the General Ledger.

The General Ledger then Feeds the Income Statement and Balance Sheet Reporting Worksheets, and TaDa! You have a Bullet Proof Bookkeeping System in a Spreadsheet.

This is easy to learn about now. It looks easy because it is now.
Building it from scratch took a lot of work, as is always the case.

A month's worth of Credit Card Transactions can be manually downloaded from a banking institution, categorized and crosschecked with statement data and the balance sheet in 5 minutes.

Ten minutes if you are getting side tracked.

The same for a checking account too.

An old Video exists with this. A new one is coming soon...

It's FAST...


This system was built to be bullet proof.

Unlike other accounting software, the user can totally foobar the interface and they can totally foobar their data. BUT who cares...

The file can be restored easily given it's being backed up in real time and the cross check systems provided by the statements and the Balance Sheet, along with four other data integrity tools make finding errors child's play.

It takes a Pro 20 to 40 minutes to setup a new file.

Users can become educated in 30-60 minutes and really proficient after 3 to 4 cycles of bookkeeping, which could be practiced in under 2 hours.


What's better than a Cloud Based Spreadsheet with a Transparent Balance Sheet??

This template, along with all others are FREE and no User Account is Required for Download.


They are free of structured data silos.
No user names or accounts are required for downloading the Templates.
No upfront costs or ongoing fees.
No more eaves dropping from Software Vendors.
This is Decentralized Software with the Users Privacy our greatest interest.

This is as private as it can get in the Cloud, and if that's not private enough, use the spreadsheet templates as a guide to create your own more private.

We are supported by voluntary donations and voluntary licensing agreements.

Welcome to a new Computing Paradigm and Welcome to a New Age for Small Business Accounting.

Other Facts, Features & Key Beliefs

Facts and Features

Demo Data - The Template comes with 1 years worth of Demo Data in it. We provide a faux banking website with that same data for training and education for those without an existing small business to learn with.

Positive and Negative Values vs Debits and Credits - The initial offering uses Positive and Negative Values on the front end because that is in the best educational interest of Small Business People. Ignoring the Dogma that is Debits and Credits has been a huge hit that is skyrocketing as we speak...

One of over 18 Templates -- This is only one of over 18 templates that are part of our 6 Box Model for Accounting Systems.

We have a LOT more to offer than just a Bookkeeping Module.

Key Beliefs

An Isolated Bookkeeping Module - We believe the Bookkeeping Module for Tax Accounting for a Small Business should be digitally separate from ALL OTHER SYSTEMS. There is zero benefit in connecting it with any other systems. Thus a switch to ZAP's Bookkeeping Module should not interrupt any other systems. Even better, it can be run in parallel with anything currently in play until unsure users are on their way. That's why it's such a great place to start.

Multiple Monitors - All Small Business People should be working on computes with multiple monitors and an external mouse whenever possible.

CPA Involvement - All Small Business People should have an affordable and ZAP educated CPA file their taxes. It just makes sense once the entire Taxation System is understood properly.

As a CPA you play a critical role in the Emotional and Mental well being of your clients.

You care about them more than they'll ever know.

For most of you, this will be the first time in your career that you have truly paradigm busting information to share.

With it, you are a Healer now.

ZAP Accounting Software creates data independent software solutions in Google Sheet Templates for Accounting and Bookkeeping solutions second to none.

Mark this day on your Calendar.

It is the day your World View changed.

Oh. And one more thing...

Are you ready to dawn your Healer Headdress yet?

We need you to help us spread the Word.

Are you ready for the New Age of Computing?

We're Here.

It's Here.

Join Us.