Bookkeeping Tools, Integrity, and Your Month of Books

What You Will Learn

• Set up a cash book in a spreadsheet with formulas
• Describe what accounting software does and when to use it
• Apply internal controls and honest practices
• Complete one month of books with a P&L and reconciliation

Lesson Notes

Spreadsheets for Bookkeeping

A spreadsheet can do the math for you. Put Date, Description, Account, Money In, Money Out, and Balance in columns A to F. If the first entry is in row 2, the balance formula in F3 is =F2+D3-E3; copy it down. Use =SUM(D2:D40) to total a column, and a filter to see one category. Save often and keep a backup copy.

Accounting Software

Online accounting programs (some free, some paid) can connect to a bank account, sort transactions into your chart of accounts, send invoices, track bills, and produce a P&L and balance sheet with one click. They do double-entry bookkeeping behind the scenes. Software saves time, but it does not replace your judgment: you still review every category and reconcile every month. Paper books are fully valid, especially when starting out.

Integrity and Internal Controls

• Record every transaction, including cash sales.
• Never hide income or invent expenses.
• Keep receipts and do not alter documents.
• When possible, have a second person review the books (an accountability partner, mentor, or bookkeeper).
• Protect passwords and personal information; back up records.
• If you find a mistake from the past, correct it openly and ask for help. Integrity guides the upright.

Bringing It All Together

Over this course you have learned to separate money, set up accounts, keep a cash book, track receivables and payables, reconcile the bank, read financial statements, price for profit, and plan for taxes. The final project puts it all into one month of real-looking books.

Key Terms

In-Class Activities

Spreadsheet Cash Book

Enter Joy's March cash book (Module 3) into a spreadsheet, or onto a paper sheet with formula boxes. Write the balance formula for row 3 and the SUM formulas for money in and money out. Confirm the ending balance is $746.70.

Integrity Case Studies

Discuss in small groups: a) A customer pays cash and says, "You don't have to write that down." b) A friend suggests listing family groceries as business supplies. c) You find a $50.00 mistake from two months ago. What would integrity do in each case?

Assignment: Final Project Submission

Submit your Month of Books (see the Final Project section), including your cash book, P&L, bank reconciliation, and reflection.

Graded with the Final Project Rubric.

Reflection Journal

Proverbs 11:3 says integrity guides the upright. How has this course changed the way you think about money, records, and honesty? What kind of business owner do you want to be known as?

Prayer focus: Thank God for the skills you have gained and ask Him to guide your business with integrity.

Integrity That Guides

Proverbs 11:3 says, The integrity of the upright shall guide them. Integrity is not just avoiding wrong. It is a guide that shows you the next right step when no one is watching.

Tools can help. A spreadsheet can calculate running balances with a simple formula. Accounting software can sort transactions, send invoices, and build reports in seconds. But no tool can supply honesty. Only you can decide to record every cash sale, keep personal spending out of the business, and correct mistakes openly.

Accountability helps too. Ask a mentor, a trusted friend, or a bookkeeper to look over your books from time to time. Two are better than one. A second set of eyes catches errors and strengthens your resolve to stay honest.

Look at what you have learned: separating money, setting up accounts, keeping a cash book, invoicing, reconciling, reading statements, pricing, and planning. Your Month of Books proves it. God has begun a good work in you, and He will carry it on.

Think About It

1. Will you start your business books on paper, a spreadsheet, or software? Why? ______________________
2. Who could be an accountability partner for your business? ______________________
3. What kind of business owner do you want to be known as? ______________________

Daily Devotions for Week 8

Guided by Integrity

The integrity of the upright shall guide them: but the perverseness of transgressors shall destroy them.— Proverbs 11:3 (KJV)

Integrity is a guide that leads us safely.

Reflect: Where do you need integrity to guide you?

Pray: Lord, let integrity guide me.

Do: Record every transaction in your final project, including the small ones.

A Good Name

A good name is rather to be chosen than great riches, and loving favour rather than silver and gold.— Proverbs 22:1 (KJV)

Honest books build a good name that money cannot buy.

Reflect: What do you want your name to stand for?

Pray: Lord, help me build a good name.

Do: Check your final project once more for accuracy.

Two Are Better

Two are better than one; because they have a good reward for their labour.— Ecclesiastes 4:9 (KJV)

Accountability makes us stronger and our work better.

Reflect: Who could help keep you accountable?

Pray: Lord, give me faithful partners.

Do: Ask a classmate to check one page of your work.

Many Counsellors

Without counsel purposes are disappointed: but in the multitude of counsellors they are established.— Proverbs 15:22 (KJV)

Wise owners seek advice from tax professionals, mentors, and experienced business people.

Reflect: Where do you need counsel?

Pray: Lord, lead me to wise counsellors.

Do: Write the names of two people or places you could go to for business advice.

A Good Work Begun

Being confident of this very thing, that he which hath begun a good work in you will perform it until the day of Jesus Christ:— Philippians 1:6 (KJV)

God is not finished with you. What He started, He will complete.

Reflect: What good work has God begun in you through this course?

Pray: Lord, finish the good work You started in me.

Do: Write a note to yourself about how you have grown.