Configuration & Use
Configuration and Use Intro
just get to it !
Use for Business and Personal Bookkeeping (320.0 - 350.0)
320) Configure for Your Use
320.0) Configure for Your Use (Chart of Accounts, ZIDs, Stmts, RawTxns, Journals, I/S, B/S ) gDoc(4)
320.0.1) New File Configuration Survey gDoc(3) | gS | video (5:43)
320.1) Chart of Accounts Worksheet gDoc(16)
320.2) ZIDs Worksheet gDoc(3)
320.3) Statements Worksheet gDoc(6)
320.4) Raw Transactions Worksheets (Checking and CC) gDoc(9)
320.5) Journal Worksheets (Checking, CC, ExpPaidVia, General Journal, A/R) gDoc(4)
320.6) Transaction Aggregator Worksheet gDoc(3)
320.7) Income Statement Worksheet(s) gDoc(7)
320.8) Balance Sheet Worksheet gDoc(10)
320.9) _!config Worksheet gDoc(3)
330) Basic Use for your Financial Data
330.0) Basic Use - Double Entry Bookkeeping w/o Debits & Credits. A 4 Step Process ( 6 pages ) gDoc(6) | diagram
Other: Full presentation on Single and Double Entry Bookkeeping & 4 Step Double Entry Accounting LucidChart(12)
Detailed Documents
Step 1 - Record Transactions "Accurately" (diagram)
331.1.1) Input Checking and Credit Card Transactions into rawTxns Worksheets gDoc(15)
331.1.2) Copy/Input your Checking and Credit Card Transactions into Journal Worksheets gDoc(7)
331.1.3) Input Statement Data into Statements Worksheet gDoc(8)
331.1.4) CONFIRM STATEMENT BALANCES MATCH RUNNING BALANCES FOR ACCURACY gDoc(8)
Step 2 - Categorize Transactions
331.2) Categorize Transactions (& Split Transactions) gDoc(10) | diagram
Step 3 - Review your Income Statement
331.3) Review Income Statement Worksheet (aka Net Income Statement) gDoc(12) | diagram
Step 4 - Review your Balance Sheet
331.4) Review Balance Sheet Worksheet (aka Comparative Net Worth Statement) gDoc(9) | diagram
340) Advanced Use for your Financial Data
ExpensesPaidVia Journal
General Journal
350) FAQs and Trouble Shooting for Your Use
350.99) Known Bank Statement Issues gDoc(3)
Use for Education or Life Simulation (410.0 - 430.0)
410) Demo Data File for Education & Bilbo's Bank Simulation System
420) Financial Modeling with the Transaction Generator
This Bookkeeping module contains four worksheets which can be used to create sample data. That is documented on the Box 5 > Transaction Generator page.
430) Bank Statement Generator to Create Faux Banking Docs and for Data Simulation
This Bookkeeping module contains one worksheet related to a Bank Statement Generator process. There is an entirely separate file template that is used to complete the faux statement and CSV file generation process. Information on that can be found on the Box 5 > Bank Statement Generator page.
This data is typically posted on a Faux Banking Website. Our documents on that can be found at Box 5 > Faux Banking Website .