FAITH • FAMILY • CREATIVITY Digital books for US$5 each
DWAYNE WORLD

Excel worksheet sample — Excel preview

Five worksheet excerpts, plus the front and back covers. View the sample below. Purchase the complete book using Buy Me on its product page.

Front cover
Front cover

Worksheet sample 1: Tracker

Read-only excerpt from the Excel workbook. The purchased workbook is editable.

Dwayne World Finances Tracker: Children's Savings
It is more blessed to give than to receive. Acts 20:35 (KJV, excerpt)
Edit pale gold cells. Amounts use one currency of your choice. No currency conversion.
Currency (type here):
New spending analysis: open Spending Review. Enter household transactions once in Money Log.
MonthOpening balanceSavings targetReceivedUsed / givenNet amountClosing balanceTarget still needed
January000
February000
March000
April000
May000
June000
July000
August000
September000
October000
November000
December000

Worksheet sample 2: Spending Review

Read-only excerpt from the Excel workbook. The purchased workbook is editable.

Children's Savings spending review
Choose a month or All months. Enter amounts once in Money Log. Gold cells are editable.
Review periodAll monthsCurrencyYour currency
No transactions entered. Add your income, bills and other spending in Money Log.
Cash flowAmountHow to read your results
Income01. Money Log: select month, type and category. Enter positive amounts; choose Expense refund for returned purchases.
Savings withdrawals02. Category Budget: set monthly budgets and any reduction percentage you choose. Totals and percentages update.
Expenses before refunds03. Bills: match each bill name exactly to the Money Log description. Paid amounts update automatically.
Expense refunds04. Review the over-budget amounts, largest spending share and cutback potential before making changes.
Net expenses0Savings and debt payments are shown separately from expenses. Savings withdrawals are not income.
Debt payments0All months compares spending with 12 monthly budgets. Start a fresh copy for each new 12-month period.
Giving0Pie charts show positive net amounts. Refunds exceeding purchases remain visible in the exact tables.
Savings contributions0Tracker is the original purpose-specific tool. Its activity is not added to these household totals.
Net cash outflow0Use one currency throughout. Small Business cash totals are not accounting profit or tax calculations.
Money remaining0
Outflow / income
User-selected cutback potential0
Charts appear after positive transactions are entered. Exact amounts and percentages are in Category Budget.

Worksheet sample 3: Monthly Summary

Read-only excerpt from the Excel workbook. The purchased workbook is editable.

January to December cash flow
MonthIncomeSavings withdrawalsExpenseRefundsNet expensesDebt paymentsGiving
January0000000
February0000000
March0000000
April0000000
May0000000
June0000000
July0000000
August0000000
September0000000
October0000000
November0000000
December0000000
TOTAL0000000

Worksheet sample 4: Category Budget

Read-only excerpt from the Excel workbook. The purchased workbook is editable.

Category budgets and cutbacks
Review period: All months
Monthly budget and cutback percentage are your choices. No reduction is assumed.
CategoryGroupMonthly budgetCutback %Net expenses% of expenses% of incomeBudget for period
Rent / mortgageHousing0
Home maintenanceHousing0
ElectricityUtilities0
WaterUtilities0
InternetUtilities0
Mobile phoneUtilities0
Gas / cooking fuelUtilities0
GroceriesFood0
Dining outFood0
Coffee / snacksFood0
FuelTransport0
Bus / taxiTransport0
Vehicle costsTransport0
InsuranceFamily0

Worksheet sample 5: Bills

Read-only excerpt from the Excel workbook. The purchased workbook is editable.

Bills paid and remaining
Match Bill name to Money Log Description exactly. Amount paid includes expense refunds.
Review period: All months
Bill nameCategoryMonthly planPlan for periodNet paidRemainingPaid %Autopay / notes
Rent / mortgageRent / mortgage0
ElectricityElectricity0
WaterWater0
InternetInternet0
Mobile phoneMobile phone0
Gas / cooking fuelGas / cooking fuel0
InsuranceInsurance0
Vehicle costsVehicle costs0
School / childcareSchool / childcare0
SubscriptionsSubscriptions0
Medical / dentalMedical / dental0
Other billCustom expense 10
Record bill payments once in Money Log. The plan here is separate from category budgets.
Back cover
Back cover
Back to Menu