Excel Financial Management System

As the Bookkeeper of my own grocery store, I've meticulously developed an Excel workbook template to streamline financial management. Rooted in the accrual basics of accounting and tailored to align with the unique business approach of the store, this comprehensive template is a cornerstone in daily operations.

The workbook contains the following sheets:

General Ledger

• Double-entry journal of all financial movements of the grocery daily

• Transactions categorized by date, account, detail, debits, and credits

Balance Sheet

• Snapshot of all transactions of the General Ledger summarized

• Formulas used: SUM(), SUMIFS()

Income Statement

• Snapshot of revenue, expenses, gains, and losses of the grocery store

• This the spreadsheet is connected to an Excel Workbook called POS_and_sales

• Formulas used: SUM(), SUMIFS()

Cash Flow

• Snapshot of the amount of cash and cash equivalents entering and leaving the grocery store

• Operating Activities are connected to the POS_and_sales workbook, while Investing & Financial Activities are connected to the General Ledger

• Formulas used: SUM(), SUMIFS()