What the Sandton seller needed
The client was a small online retailer based in Sandton, Johannesburg, selling directly to customers across South Africa. Orders were coming in steadily, but the bookkeeping side was lagging behind day to day sales. Payments from card, EFT and delivery partners had to be matched manually, and payroll for a small team was being handled in bits and pieces rather than on one clear schedule.
The brief was practical. They wanted cleaner order tracking, a better way to line up payouts with sales, and a monthly process that would not eat up evenings and weekends. They also needed payroll support for a lean team, with payslips, leave tracking and deductions handled properly. The owner said the main goal was simple: spend less time on admin and more time selling.
- Client type: micro business online seller
- Location: Sandton, Johannesburg
- Main issue: mixed sales records and slow month end checks
- Need: bookkeeping plus payroll support in one process
The constraints we had to work around
Like many micro businesses, this seller did not have a full finance team or a spare office person to keep up with every invoice, statement and payment slip. Sales moved quickly, stock changed often, and there were busy days where orders landed late into the evening. In addition, the team worked across different devices and locations, so records were not always captured in the same place.
We also had to keep the process light enough for a small team. No one wanted a complicated monthly routine that depended on one person remembering every step. The system had to work even during load-shedding, when connectivity drops or staff are away on leave. And because the business operated from Sandton but sold nationally, the numbers needed to stay clear enough for SARS, payroll checks and bank reconciliation. A neat process was important, not just pretty reports.
- Small team with limited admin time
- Orders and payments recorded across different systems
- Monthly reconciliation had to stay simple
- Payroll needed to keep running when staff were off-site or unreachable
How Affo sorted the process
We started by mapping the full month end cycle, from order capture to bank reconciliation and payroll processing. Then we cleaned up the working files so each sale, payout and fee could be matched against the correct entry. The focus was on consistency. Once the records followed the same structure every time, the owner could see what had cleared, what was still outstanding and what needed follow up.
For payroll, we set up a monthly rhythm with clear cut-off dates for timesheets, leave and deductions. Payslip processing was handled together with payroll reporting so the client had one point of review before payment. We also put in a simple handover process for changes like new staff, terminations and holiday cover. That cut down on missed details and avoided last-minute scrambles.
- Bookkeeping cleanup for order and payout records
- Monthly payroll schedule with clear cut-off dates
- Payslip processing and deduction support
- Leave tracking and termination pay handling
- Regular payroll reporting for review before payment
Timeline and delivery in four weeks
The project ran over four weeks, with the first week spent on access, document collection and sorting the historical records. In week two we aligned the sales and payment entries, then flagged gaps where backup slips or bank references were missing. Week three focused on the payroll side, including staff records, leave balances and the reporting format. By week four the client had a cleaner month end flow and a process they could repeat without starting from scratch each time.
We kept the touchpoints short and practical. The owner did not have time for long calls, so we used brief check-ins, shared notes and a fixed checklist. That made it easier to move quickly without dropping details. A small admin issue can snowball very fast, so keeping each step clear helped a lot.
- Week 1: records collected and sorted
- Week 2: sales, payouts and bank entries matched
- Week 3: payroll structure and reporting set up
- Week 4: handover and monthly cycle confirmed
Results the client could see straight away
Once the records were cleaned up, the client had a far better view of daily trading and month end numbers. Order tracking became easier to follow, which made it simpler to see where stock, sales and payouts were moving. Reconciliation stopped being a long, stressful job and became a shorter routine with fewer surprises. The owner could also check payroll figures with more confidence before payday.
In practical terms, the business gained tighter control over cash flow and less admin pressure. Staff records were easier to keep current, and the payroll process no longer relied on memory or last minute messages. The owner described the main change as having more headspace. That matters when you are selling online and every hour counts. There was less backtracking, fewer missing bits and a cleaner record for the month.
- Cleaner order tracking across sales and payouts
- Faster monthly reconciliation
- Clear payroll review before payment dates
- Less time spent correcting records
What we would do again for a similar seller
If we were doing this again for another Sandton online seller, we would still start with the month end process first. That is where the pressure usually shows up. Once the sales, bank and payroll steps are lined up, the rest of the bookkeeping becomes much easier to manage. We would also keep the reporting format short and plain, so the owner can read it quickly without digging through too much detail.
For micro businesses, the biggest win is not fancy software, it is a process that gets followed. A simple checklist, fixed dates and proper handover notes can save hours every month. We would apply the same approach to online sellers in Bryanston, Sandton, Randburg, Midrand, Pretoria, Cape Town, Durban and Gqeberha, especially where the team is small and the admin load is already heavy. It keeps the numbers honest and the business moving.
- Start with month end and bank reconciliation
- Keep payroll cut-off dates fixed
- Use a short report format that owners can check quickly
- Build a repeatable routine that staff can follow even during busy periods
Key facts
| Project | Sandton Online Seller |
|---|---|
| Client type | Micro business online retailer |
| Location | Sandton, Johannesburg |
| Timeline | 4 weeks |
| Core services | Bookkeeping cleanup, monthly payroll, payslip processing, leave tracking |
| Outcome | Cleaner order tracking and easier monthly reconciliation |
