Three Scenarios > 2) Legacy Data. t=0 for All

You have legacy data AND you have it all the way back to the beginning of each account AND you want to enter it all into your template.

Statements Worksheet

Enter ZERO into the RED cell circled in RED.

This is similar to what you might see once you load in your legacy data, BUT the Value inside the red circle would be ZERO for each active data block.

Asset/Liability Journals Worksheets

This is what the opening transaction would look like except the Amount would be a ZERO.

======== Opening Balance Record Details ========

These are the same for all three scenarios. the only difference is the Amount. Scenario 1 and 2 (this one) are ZERO and Scenario 3 has a non-zero value.

  1. Date >> The Date for the entry should be the same as the First Transaction date and/or the First Statement Start Date, which ever you prefer.

      1. The date can NOT be prior to the First Statement Start Date. The system with throw an error on the Statements Worksheet. This error is to prevent accidentally entering future transactions with an errant date prior to the opening of the statement. This is a subtle but important mechanism for data integrity protections.

  2. Payor/Payee/Description >> Enter anything you'd like. "Opening Balance" is common.

  3. Amount >> $0.00

  4. Acct2 >> "99_opening_balance" OR "Opening Balance" OR the comparable Opening Balance Account listed in the bottom of your chart of your Chart of Accounts that is a ZAPSpecial Account designated for Opening Balances.

      1. This value MUST be selected from the drop down. If you do not see a proper value look in your Chart of Accounts to be sure it's there and then look for it in the Drop Down again. If you can't find it, seek professional support. Do NOT make-up the account in the drop down box. That will leave a red flag in the corner of the drop down box and that is not good.

  5. TxnID >> 0

      1. This is very important you set this to ZERO to provide a proper sort functionality in the future.

A Balance Sheet Cross Check that won't provide much insight other than a non-relevant bug...

If you were to view the Balance Sheet with a Start Date and an End Date equal to the earliest date you have in your Bookkeeping records you would see a lot of zeros.

  • If you expanded the drill down report and set it to "End Date" you would see two records (or more) attributing to those zeros.

  • You would also see a non-relevant bug related to zero transaction handling in the the debits and credits column s, if those were active.

  • You would not see money-fabrication education found with non-zero opening balances.

Please see Scenario 1 to see the non-relevant bug related to Zeros.

Please see Scenario 3 if you'd like understand more about money fabrication from thin air.

Or just keep on moving with your own account!

You're Done here!

The next thing you need to do is populate your file with your data. Use the information for Use in the BK User Guide to populate the file.

Head out to the BK User Guide now!