You deliver a service on Monday, send a customer your bank details on Tuesday and receive part payment on Thursday. By the following week, you are trying to remember whether the customer still owes money, what you spent on transport and whether the total in your notebook matches your bank account. Small gaps like these can make a busy business feel financially confusing.
You do not need sophisticated accounting software to begin organising simple records. Google Sheets can help you prepare basic invoices, acknowledge payments and track money received and spent. It is a spreadsheet application, not a replacement for a qualified accountant or every statutory record requirement. Used carefully, though, it can give a small Nigerian business better visibility into everyday transactions.
This guide shows you how to build a practical system from scratch, with column layouts, formulas, a worked naira example and a routine for keeping the records useful.
Understand the three documents before building anything
An invoice is a request for payment. It tells a customer what was supplied or agreed, the amount payable and when payment is due. An invoice does not by itself prove that the customer paid.
A receipt acknowledges money actually received. If you send a receipt before confirming payment, you may create confusion or disputes.
An expense tracker records money leaving the business and why it was spent. It should help you identify operating costs, keep supporting evidence and compare your records with bank transactions.
The fourth record worth keeping is a transaction log, covering actual money received and money paid out. Separating invoices from confirmed cash movements helps prevent you from counting unpaid bills as cash already available.
Step 1: Create your Google Sheets workbook
Open Google Sheets while signed in to the Google account you use for business administration. Select a new spreadsheet and give it a descriptive name such as “Business Records 2026”. Google documents this basic process in its official Sheets help pages.
Create four tabs at the bottom of the workbook:
Invoices for amounts requested from customers.
Payments for money actually received and money spent.
Expenses for detailed spending records and evidence links.
Dashboard for a quick monthly summary.
You can add a fifth tab called Receipt Template if you frequently issue payment acknowledgements. Keep templates separate from the raw transaction data so you do not accidentally overwrite your records when preparing a new document.
Step 2: Build an invoice register
On the Invoices tab, create these headings in row 1:
ColumnHeadingWhat to record AInvoice IDUnique reference, such as INV-2026-001 BInvoice dateDate the invoice was issued CCustomerName or business name DDescriptionProduct or service supplied EQuantityNumber of units FUnit pricePrice per unit in naira GInvoice totalQuantity multiplied by price HAmount receivedConfirmed payment applied to this invoice IBalanceAmount still outstanding JDue dateAgreed payment deadline KStatusPaid, Unpaid or Overdue In cell G2, enter =E2*F2. In cell I2, enter =MAX(0,G2-H2). In K2, enter =IF(A2="","",IF(I2<=0,"Paid",IF(AND(J2<>"",TODAY()>J2),"Overdue","Unpaid"))).
Copy those formulas down for each invoice row. The status formula assumes a valid date in column J where a due date is available. Do not rely on the automatically calculated status without checking that the input values are correct.
For services with several line items, use a separate printable invoice layout and add the line-item totals to the register. An invoice register with one row per invoice is useful for monitoring, while a customer-facing invoice can show the full item breakdown.
Step 3: Make a customer-facing invoice template
Create a separate sheet named Invoice Template. At the top, include the business name, verified contact details and any required business identifiers. Then add the invoice number, issue date, customer's name, service description, quantity, unit price, total due, payment details and payment deadline.
For example, use columns A to D for a small line-item table:
ABCD DescriptionQuantityUnit price (₦)Amount (₦) Website content edit212,00024,000 Product listing clean-up18,0008,000 If the first item occupies row 10, put =B10*C10 in D10. Copy the formula to each item row. If items occupy rows 10 to 14, the total can be calculated with =SUM(D10:D14). In the illustration, the total is ₦32,000.
Put the amount already paid in a separate cell and subtract it from the total to show the outstanding balance. If the customer paid ₦12,000, the remaining balance is ₦20,000. Use the correct business payment information and avoid placing personal account details on public templates.
Where tax invoicing or specialised compliance rules apply, obtain appropriate professional guidance about required identifiers, tax fields, timing and e-invoicing. A spreadsheet document is not automatically a legally sufficient tax invoice.
Step 4: Record actual money movements separately
In the Payments tab, use the columns below:
A: Date | B: Reference | C: Direction | D: Customer/Payee | E: Description | F: Category | G: Payment method | H: Amount (₦) | I: Reconciliation status | J: Notes
Use Money In or Money Out in column C. Only record confirmed receipts and payments here. Enter amounts as positive numbers; the direction tells you whether they increase or decrease cash. A refunded or reversed payment should have a clearly documented corrective entry rather than being silently deleted.
Imagine a small design business with these illustrative transactions:
DateDirectionDescriptionAmount 2 NovMoney InCustomer deposit₦24,000 3 NovMoney OutInternet data₦4,500 4 NovMoney InCompleted design job₦18,000 5 NovMoney OutTransport₦3,000 6 NovMoney OutPrinting₦5,500 In this fictional example, cash received is ₦42,000, cash paid out is ₦13,000, and net cash movement is ₦29,000. This does not necessarily equal accounting profit. It excludes any unpaid supplier bills, depreciation, owner withdrawals, taxes and other relevant adjustments.
For money received, use =SUMIF(C2:C,"Money In",H2:H). For money paid out, use =SUMIF(C2:C,"Money Out",H2:H). Subtract the second result from the first to see overall net movement for the data in that tab. Google's official documentation confirms how SUMIF performs conditional sums.
Step 5: Create a more detailed expense tracker
A general Payments tab tells you how much money went out. The Expenses tab helps explain what the money was used for. Create these headings:
Date | Expense ID | Supplier | Category | Description | Amount (₦) | Payment method | Receipt or evidence | Business purpose | Recorded by
Possible categories include transport, internet and data, materials, delivery, rent, utilities, equipment maintenance and professional services. Use categories that match the way your business operates. A food vendor may need raw materials and packaging; a digital freelancer may need internet, subscriptions and equipment.
Choose one consistent way to record each expense. If you enter it in both Payments and Expenses, the Dashboard must not add both tabs together as if they represent different payments. One approach is to treat Payments as the cash ledger and Expenses as the supporting detail, linked through the same reference ID.
Keep electronic copies of receipts or photographs of paper documents in an appropriately secured folder. If you link to them from a sheet, make sure only authorised people have access. A link in a spreadsheet is not a substitute for actual backup or responsible records management.
Step 6: Add dropdowns to reduce mistakes
In Google Sheets you can select cells, choose Insert → Dropdown or use Data → Data validation, then define permitted choices. Google's official help explains this feature. Create dropdowns for Direction, Category, Payment Method and Reconciliation Status.
For example, in Direction choose Money In and Money Out. In Payment Method choose Transfer, Cash, POS and Other. In Reconciliation Status choose Pending, Matched and Needs Review.
Dropdowns reduce spelling variations such as “Transfer”, “Bank transfer” and “transfr” that make totals harder to summarise. They do not prevent someone from entering a wrong amount, so regular review remains necessary.
Format money cells as naira currency through Format → Number, using an appropriate custom-currency option if needed. Set the spreadsheet's locale and time zone consistently so dates and number formats are interpreted correctly.
Step 7: Build a simple dashboard
Your dashboard can begin with four figures: money received, money paid out, net cash movement and unpaid invoice balances. You do not need charts or advanced formulas at first.
A simple workbook-wide formula for cash received is =SUMIF(Payments!C2:C,"Money In",Payments!H2:H); for cash paid out use =SUMIF(Payments!C2:C,"Money Out",Payments!H2:H). To find total outstanding invoices, use =SUM(Invoices!I2:I).
If you want only one month's figures, add a date condition with SUMIFS rather than summing the entire sheet. For example, to total November 2026 money received when column A contains proper date values:
=SUMIFS(Payments!H2:H,Payments!C2:C,"Money In",Payments!A2:A,">="&DATE(2026,11,1),Payments!A2:A,"<"&DATE(2026,12,1))
This formula assumes dates are stored as dates, not plain text. Change the month boundaries for the reporting period. Your dashboard is only as accurate as the underlying entries, so correct missed transactions before drawing conclusions.
Step 8: Issue receipts only after confirming payment
A basic receipt can include the receipt number, business name, payer, payment date, amount received, payment method, transaction reference, purpose and any balance outstanding. If a customer makes part payment, clearly say it is a part payment and state what remains due.
For example: “Receipt RCPT-2026-014 confirms ₦12,000 received on 10 November towards Invoice INV-2026-014. Outstanding balance: ₦20,000.” The amounts are illustrative.
Check your bank statement or payment processor records before marking an invoice paid. A screenshot provided by a customer is not always sufficient proof that money has reached your account. If the transaction is pending, acknowledge that you are checking rather than issuing a false confirmation.
To send a neat invoice or receipt, define the print area and use Google Sheets' File → Print workflow, saving as a PDF where supported by the browser or print settings. The official Google help pages explain printing and exporting spreadsheets. Inspect the PDF first; avoid sending a file with cut-off columns or hidden information.
Step 9: Reconcile the sheet with your actual account
At least once a week, compare the recorded transactions with your bank account, POS settlement records, cashbook or payment-service history. Match each transaction by date, amount and reference. Flag differences for investigation.
Common differences include bank charges, delayed settlement, duplicate entries, cash collected but not recorded, owner spending from the business account and refunds. Do not force the numbers to match by deleting unexplained items. Create a note, investigate and document the correction.
Where you use more than one account, record the account or channel used for each transaction. Transfers between business accounts should not be mistaken for new sales revenue. A transfer may change where cash is held without increasing overall business income.
Step 10: Protect the records and keep ownership clear
Store the workbook under a business-controlled account and enable available account-security protections. Give staff only the access needed for their duties. Google Sheets lets owners share a file with viewer, commenter or editor permissions, and it provides protected ranges. However, Google's own guidance warns that protected sheets are not a substitute for genuine security controls; people with suitable access may still copy information.
Keep backup copies periodically and agree on who can edit the master record. Do not share a workbook containing customer addresses, transaction details and personal financial information through a public link. If you hire a bookkeeper or accountant later, organised records will make collaboration easier.
Set a weekly 20-minute review: enter missing transactions, match payments, follow up unpaid invoices, file receipts and check totals. One consistent routine is usually more valuable than a complicated dashboard that nobody updates.
Frequent mistakes that distort business records
The most serious mistake is confusing invoiced sales with money received. A ₦100,000 invoice is not ₦100,000 of available cash if the customer has not paid. Another mistake is treating all money remaining in the account as profit. Stock purchases, debts, unpaid bills and taxes may affect the business's true position.
Also avoid using the same invoice number for different customers, recording only payments that arrived through one bank, leaving expenses without descriptions and entering dates in inconsistent formats. If formulas are accidentally overwritten, totals can become misleading; check formula columns before sharing reports.
Finally, do not rely on a homemade spreadsheet to resolve complex tax, payroll, inventory valuation or statutory reporting questions. An accountant or appropriately qualified adviser can help determine what records and methods are required for your particular business.
Frequently asked questions
Is Google Sheets free for a small business?
Google Sheets has a standard consumer-access option, though business-account features and storage arrangements can vary. Check current Google account and Workspace terms if your organisation needs advanced administration.
Can I use Google Sheets to create an invoice in naira?
Yes. You can enter naira amounts, use formulas and format cells as currency. Ensure the invoice includes the information required for the nature of your transaction and any applicable legal obligations.
What is the difference between an invoice and a receipt?
An invoice requests payment; a receipt confirms payment has actually been received. One customer may need several receipts for a single invoice if payments are made in instalments.
Why does my income total not match my bank balance?
The sheet may omit charges, cash transactions, reversals, transfers, withdrawals or expenses. Reconcile transactions and distinguish cash movement from accounting profit.
Can staff update the tracker from their phones?
Yes, where they have an appropriate Google Sheets app and permission. Design the data-entry sheet to be simple, and review entries regularly to reduce errors.
Does a Google Sheets invoice automatically satisfy Nigerian tax requirements?
No. A spreadsheet is a document tool, not a legal certification of compliance. Tax invoices, record retention and e-invoicing obligations may depend on the business and applicable rules. Seek professional guidance where necessary.
Start with accurate entries, not complex software
A useful recordkeeping system starts with confirmed payments, clear invoice numbers, sensible expense categories and regular reconciliation. Build those habits in a simple workbook before adding charts or automation. When the business grows, you will have cleaner records and a stronger basis for choosing more advanced accounting tools.
Sources and further reading
• Google: How to use Google Sheets
• Google: Create an in-cell dropdown
• Google: Format numbers and currencies
• Google: Protect and share sheets
A. Joshua Adedeji
A. Joshua Adedeji is a leadership strategist, organisational development consultant, author, teacher and values-driven transformation leader. He writes on leadership, strategy, governance, organisational effectiveness, business, personal development and Nigeria’s social and economic transformation, connecting ideas and current realities to practical implications for leaders, institutions, entrepreneurs and citizens. His work is shaped by a commitment to clear thinking, responsible leadership, stronger institutions and the development of people and systems capable of producing lasting impact.
Reader conversation
0 approved comments