To compete for an accounts payable (AP) officer role in Tanzania, show that you can match a purchase order, goods-received record and supplier invoice, explain discrepancies, and document who approved payment. An accounting certificate may establish background knowledge, but a clean, traceable work sample makes your ability easier for an employer to assess. This guide gives you a fictional invoice test, an Excel structure and a seven-day preparation plan. It is career guidance, not an advertisement for a confirmed vacancy.
Why employers test the transaction, not just the CV
Accounts payable sits between procurement, stores, finance and treasury. A late or incorrect payment can interrupt supplies, while a duplicate or unsupported payment can harm cash flow. A strong AP officer therefore needs three abilities: documentary accuracy, respectful escalation and disciplined recordkeeping. In a distributor in Dar es Salaam, the invoice may arrive before the delivery note; in a manufacturer in Mwanza, an order may be delivered in batches. The correct response is to explain the exception, not to force the numbers to agree. Employers should verify the specific accounting software and internal approvals used in their business; no one Excel template is an official Tanzania standard.
The three-way match: purchase order, receipt and invoice
Start with a purchase order that authorises 100 units at TZS 25,000 each, excluding any tax treatment for this fictional exercise. The stores record confirms receipt of 96 units, while the supplier invoice bills 100 units. The invoice value before tax is TZS 2,500,000, but the quantity supported by the receipt is 96 × 25,000 = TZS 2,400,000. The difference is TZS 100,000. Do not assume the remaining four units were lost or that the supplier acted dishonestly. Check whether a second delivery is pending, a receipt was entered late, or the invoice should be corrected. The accounting treatment and any VAT treatment must follow actual documents and applicable rules, not this simplified case.
Build a small, audit-friendly Excel work sample
Create a fictional workbook with six tabs: purchase orders, goods receipts, invoices, exceptions, supplier statements and an approvals log. Useful columns include document number, supplier ID, item, quantity ordered, quantity received, unit price, invoice quantity, variance, reviewer and status. Use XLOOKUP or INDEX/MATCH to retrieve order details, SUMIFS to aggregate partial receipts, conditional formatting to flag mismatches, and data validation for statuses such as pending, queried, approved and paid. Include a read-me that explains your assumptions and that all records are invented. Never upload a former employer’s actual supplier files or banking details to a public portfolio.
Four exception cases an interviewer may give you
Case A: an invoice arrives twice with the same supplier, amount and reference. Hold the second item for review and check the vendor ledger. Case B: a price differs from the approved purchase order. Ask procurement for an authorised amendment before payment. Case C: goods are returned after receipt. Reconcile the credit note and outstanding balance. Case D: a supplier statement lists an invoice missing from the internal ledger. Request supporting documents and check cut-off timing. In each case, your answer should name the evidence, the person authorised to resolve it and the record you would retain.
A seven-day AP interview portfolio
Day 1: collect a target job description and highlight document control, reconciliations and ERP requirements. Day 2: build fictional purchase-order and goods-received tables. Day 3: add invoices and formulas. Day 4: design an exception register with five test cases. Day 5: reconcile a fictional supplier statement and draft a short query email. Day 6: explain a control failure in a one-page memo. Day 7: practise a five-minute walkthrough, including what you would not approve. The aim is a transparent demonstration of reasoning, not an exaggerated claim that you have operated SAP or another ERP in production.
A worked supplier statement reconciliation
Extend the example with a fictional supplier statement showing an opening balance of TZS 1,000,000, one supported invoice of TZS 2,400,000, a credit note of TZS 150,000 and a payment of TZS 1,500,000. The illustrative closing balance is TZS 1,750,000. Show the calculation as opening balance plus invoices, less credits and payments. Label this as an exercise with taxes deliberately excluded. A statement balance is a reconciliation starting point, not payment authorisation.
Now make the exercise harder: the supplier has not allocated the TZS 1,500,000 payment to its invoice, while your bank record shows the transfer was made. Create an outstanding-allocation line rather than posting the payment a second time. Record the transfer reference, the date of your query and the evidence still needed. An interviewer should be able to see how you distinguish a timing difference from a missing document.
A simple exception register you can explain
| Finding | Evidence to check | Next action |
|---|---|---|
| 100 invoiced, 96 received | PO, receipt and delivery schedule | Query remaining units; obtain authorised treatment |
| Repeated invoice reference | Supplier ledger and earlier posting | Hold potential duplicate for review |
| Payment not allocated | Remittance and supplier statement | Request allocation; retain the audit trail |
Add an owner, review date and status to every exception. A colour flag without an accountable next step is only decoration. Keep supporting documents in a consistent folder structure and use one stable reference in your workbook, memo and query email. Your reviewer should not have to guess which record supports your conclusion.
A five-minute interview walkthrough
Spend the first minute explaining the fictional business and assumptions. Use the second minute to trace one clean invoice from order to receipt. In minute three, demonstrate the quantity mismatch. In minute four, show the statement reconciliation and outstanding items. Finish with the control you would improve and the decision you would escalate. Let the interviewer challenge a formula or ask for a different scenario; understanding the control matters more than a polished dashboard.
Before applying, use the free JobsTanzania ATS CV scan to review how clearly your CV presents the relevant evidence. Then browse genuine finance vacancies. Describe this workbook as independent practice and distinguish it from actual employment. For a related record-control exercise, read our inventory controller portfolio guide.
How to describe AP evidence on your CV
Replace “good at accounting and Microsoft Excel” with a truthful evidence statement. For a training project: “Built a fictional 25-invoice AP reconciliation workbook with three-way matching, exception tracking and reviewer sign-off.” If the work was part of a real job, describe the actual volume, controls and outcome only when you can substantiate them and disclose no confidential information. Employers will value someone who can explain why a payment was held as much as someone who can process a clean invoice quickly.
Use HumanValue learning as a specific next step
HumanValue’s Learning Center offers workplace learning. Review the current Excel course outline and price to decide whether it addresses the formulas, sorting, filtering and reporting skills your AP sample needs. A course supports practice; it is not an accounting licence or a guarantee of employment. Explore the course at HumanValue Learning Center. If your applications need stronger positioning, review JobsTanzania seeker support at Job Seeker Premium, and compare the current checkout terms before paying. Ordinary job applications remain available without buying Premium.
Frequently asked questions
Do I need a CPA qualification for an accounts payable role?
Read the actual vacancy. Employer requirements vary with seniority, responsibilities and the qualifications specified. Describe your own qualification accurately; a practice workbook does not replace a mandatory credential.
How do I explain a three-way match at an interview?
Name the purchase order, goods receipt and supplier invoice. Compare the supplier, item, quantity and approved price, then explain the unresolved difference and the person authorised to decide the next step.
Should I pay an invoice when goods are partly delivered?
Do not make a universal payment decision from this exercise. Check the contract, payment terms, receipt evidence and approval policy. Your portfolio should show how you flag a partial delivery and seek an authorised decision.
Can I include real supplier documents in my portfolio?
Use fictional data unless you have clear authorisation and an appropriate approved sharing process. Remove bank details, personal information, prices and other confidential business records from public work samples.
Will a CV scan or course guarantee an interview?
No. The free ATS scan can help identify presentation gaps, and learning can improve a specific skill. Recruitment outcomes depend on the employer, vacancy requirements and the evidence you present.
Your next action
Download or create a fictional invoice set, build one clean reconciliation and prepare to explain a mismatch without guessing. Use the Learning Center for Excel gaps, and keep your JobsTanzania CV focused on verifiable finance evidence. A credible portfolio does not promise a job, but it gives an interviewer a concrete basis for discussing your judgement.
Sources and useful services
- HumanValue Workplace Excel Essentials
- HumanValue Learning Center
- JobsTanzania Job Seeker Premium
- Tanzania Revenue Authority
Editorial review: 5 November 2026. Career guidance; the numerical examples are simplified training exercises. Illustrative cases are fictional.
