ZAP ACCOUNTING SOFTWARE
  • Home
  • Testimonials
    • Sales System Templates
    • Bookkeeping Template
  • The Challenge
  • Education
    • Intro Videos
    • ----------------------
    • Accounting Studio Magic >
      • ASM 101
      • ASM 102
    • Software Systems >
      • Spreadsheets 101
      • Sales Systems 101
      • Bookkeeping 101
      • DIY Software Programming 101
    • ----------------------
    • Visuals
    • Books & Pamphlets
    • ------------------------
    • Empowerment
    • Reimagination
    • ----------------------
    • End User Benefits
    • FAQs
  • Software
    • "Software" Intro
    • Via the 6 Box Model
    • ------ By Box -----
    • Box 1 >
      • Invoicing 101 - Petes Electric
      • Statements 101 - Martha's Counseling
      • Legal Billing (images only)
    • Box 2 >
      • Expense and Profit Analysis
      • Time and Attendance
      • Payroll System
    • Box 3 >
      • Bank Deposit Prep WB
      • Acc'ts Receivable - Digital Bar Tab
      • Acc'ts Receivable - Double Entry
    • Box 4 >
      • Check Journal Example
      • Check Journal w/ 3 up Printing
      • Acc'ts Payable - Simple Digital List
    • Box 5 >
      • Bookkeeping
      • Transaction Generator
      • Bank Statement Generator
      • Bilbo's Bank - Faux Bank Website
      • Manual Balance Sheets
    • Box 6 >
      • Tax Prep Summary Worksheet
      • Tax Return Journals
      • Taxable Income Tracking
      • Tax Simulation & Estimating (Fed, State, PremTaxCred)
      • Real Estate Transaction Journal
      • Sales Tax Remittance Tracking
    • ------------------------
    • Other >
      • Accounting Master File
      • DIY1 uBoundGScriptProject
  • More...
    • Orientation >
      • ------ INFORMAL ------
      • Models & Data Flow for folks on the GO!
      • Problems, Solutions and Bigger Backstory
      • ------- FORMAL -------
      • Step 1 - Welcome
      • Step 2 - Custom For You... >
        • Accounting Alchemists
        • Categorizing Crackerjacks
        • Simmering Sages
        • Sorcerous Students
        • Magical Millennials
        • Enchanting Educators
        • Spreadsheet Gurus, Javascript Wizards, Database Devils, & Full Stack Devs too...
      • Step 3 - Reunited!
      • Step 4 - The Accounting System 6 Box Model
      • ----------------------
    • For CPAs >
      • Welcome & Orientation
      • ------ Resources -----
      • Bookkeeping Template Data Flow Details
      • Demystification Documents
      • Empowerment For CPAs
      • Balance Sheet Re-imagined
      • Income Statement Re-imagined
      • Bookkeeping Re-Imagined
      • ------------------------
      • Sea Change Notice - 11/6/2021
      • The Opportunity - 1/17/2022
    • Contribute >
      • Donate $$ Here !!
      • Suggested Licensing Fees & Donation Amounts
    • Admin > Login/Logout
    • Archive >
      • Home_out20210331
      • Commerce Snippets
    • About
    • Contact
  • Home
  • Testimonials
    • Sales System Templates
    • Bookkeeping Template
  • The Challenge
  • Education
    • Intro Videos
    • ----------------------
    • Accounting Studio Magic >
      • ASM 101
      • ASM 102
    • Software Systems >
      • Spreadsheets 101
      • Sales Systems 101
      • Bookkeeping 101
      • DIY Software Programming 101
    • ----------------------
    • Visuals
    • Books & Pamphlets
    • ------------------------
    • Empowerment
    • Reimagination
    • ----------------------
    • End User Benefits
    • FAQs
  • Software
    • "Software" Intro
    • Via the 6 Box Model
    • ------ By Box -----
    • Box 1 >
      • Invoicing 101 - Petes Electric
      • Statements 101 - Martha's Counseling
      • Legal Billing (images only)
    • Box 2 >
      • Expense and Profit Analysis
      • Time and Attendance
      • Payroll System
    • Box 3 >
      • Bank Deposit Prep WB
      • Acc'ts Receivable - Digital Bar Tab
      • Acc'ts Receivable - Double Entry
    • Box 4 >
      • Check Journal Example
      • Check Journal w/ 3 up Printing
      • Acc'ts Payable - Simple Digital List
    • Box 5 >
      • Bookkeeping
      • Transaction Generator
      • Bank Statement Generator
      • Bilbo's Bank - Faux Bank Website
      • Manual Balance Sheets
    • Box 6 >
      • Tax Prep Summary Worksheet
      • Tax Return Journals
      • Taxable Income Tracking
      • Tax Simulation & Estimating (Fed, State, PremTaxCred)
      • Real Estate Transaction Journal
      • Sales Tax Remittance Tracking
    • ------------------------
    • Other >
      • Accounting Master File
      • DIY1 uBoundGScriptProject
  • More...
    • Orientation >
      • ------ INFORMAL ------
      • Models & Data Flow for folks on the GO!
      • Problems, Solutions and Bigger Backstory
      • ------- FORMAL -------
      • Step 1 - Welcome
      • Step 2 - Custom For You... >
        • Accounting Alchemists
        • Categorizing Crackerjacks
        • Simmering Sages
        • Sorcerous Students
        • Magical Millennials
        • Enchanting Educators
        • Spreadsheet Gurus, Javascript Wizards, Database Devils, & Full Stack Devs too...
      • Step 3 - Reunited!
      • Step 4 - The Accounting System 6 Box Model
      • ----------------------
    • For CPAs >
      • Welcome & Orientation
      • ------ Resources -----
      • Bookkeeping Template Data Flow Details
      • Demystification Documents
      • Empowerment For CPAs
      • Balance Sheet Re-imagined
      • Income Statement Re-imagined
      • Bookkeeping Re-Imagined
      • ------------------------
      • Sea Change Notice - 11/6/2021
      • The Opportunity - 1/17/2022
    • Contribute >
      • Donate $$ Here !!
      • Suggested Licensing Fees & Donation Amounts
    • Admin > Login/Logout
    • Archive >
      • Home_out20210331
      • Commerce Snippets
    • About
    • Contact

Software > Box 4 > Check Journal

Template:   ZAP_b4_Check Journal  ​
Picture
Technical Details:
Approximate # of Active Worksheets: 1
Approximate. # of silent worksheets: 0 
​Array Formulas: None
Internal / Bound Script Project used? No.

External / Unbound Script Project used? No
DESCRIPTION
If you want or need to track outstanding checks, that is best done in a very simple spreadsheet separate from your formal bookkeeping module. 

This only uses two simple formulas. 
  =sum(F10:F)
  =
sumif(G10:G18,"<>c",F10:F18
)

You could add this worksheet or this functionality to a blank worksheet in your primary bookkeeping module (ZAP_b5_BK_PN) if you'd like but it's just as easy to bookmark this as a separate file. 

Image carousel
What's a HELOC in 1st?  Link coming soon...
ZAP Accounting Software - a 
220Club Initiative - copywrite 2017 and beyond...
Proudly powered by Weebly