Published: 19 November 2026 | By AOLC
Somewhere in your business, a person is reading a number off one screen and typing it into another. A quote becomes an invoice. An emailed order becomes a spreadsheet row. A customer’s details are keyed into three different systems, each time with a slightly different spelling.
If you already pay for Microsoft 365, you own most of the tools needed to stop this. This guide shows where manual data entry hides, which Microsoft 365 tools replace it, and what South African businesses must keep in mind under POPIA when they capture personal information.
Every time a person retypes a fact, you pay for the time and you risk an error. The goal is simple: capture each fact once, at the source, and let software copy it everywhere else.
Where Manual Data Entry Hides.
Most owners can name one or two obvious data-entry jobs. The costly ones are usually the quiet ones that nobody lists:
- Email to spreadsheet — orders, enquiries and supplier statements arrive by email and are retyped into a sheet or an accounting package.
- Paper and photos — job cards, delivery notes and signed forms are photographed, sent over WhatsApp and typed up later at the office.
- System to system — the same customer record is captured in your quoting tool, your accounting software and your mailing list.
- Spreadsheet to spreadsheet — branch or department files are copied into a monthly master file by hand.
- Document to document — the same names, addresses and amounts are typed into quotes, contracts and letters.
1×
The rule that fixes most of this: type it once. Anywhere else the same information appears, it should be a copy made by software, not a second act of typing.
The Microsoft 365 Toolkit You Already Own.
You do not need new software to start. These are the pieces that matter, and how each one removes typing:
- Microsoft Forms — a web or phone form that people fill in instead of emailing you a message. Answers arrive as structured data, with required fields and choice lists, not as free text.
- Microsoft Lists and SharePoint lists — a proper table for the records a form creates: requests, jobs, assets, supplier details. Each column can be a dropdown, a date, a number or a person, so bad data is rejected at the door.
- Excel with Power Query — the “Get & Transform” feature in desktop Excel can combine a whole folder of monthly files into one table, and refresh it with a click, so nobody copies and pastes between workbooks.
- Power Automate — the connector between all of these. When a form is submitted or an email arrives, it creates the record, files the attachment and tells the right person. Our Power Automate getting-started guide explains flows in plain English.
- Power Apps — simple phone and tablet apps for capturing information in the field, such as site inspections or stock counts, straight into a list. Check what your plan includes before you build on it.
- Outlook — shared mailboxes, rules and templates keep repeated text out of the typing queue, and feed the flows above.
Tip
What each Microsoft 365 plan includes changes from time to time, and some features (premium connectors, AI document reading, desktop flows) need an extra licence. Check the current terms for your own plan before you design around them. Our Microsoft 365 licensing guide covers the main plans, and we can quote licences through our Microsoft CSP service.
Five Fixes That Work.
- Replace emailed requests with a form. Instead of “email us your order”, send customers or staff to a Microsoft Form. Make the key fields required, use dropdowns for anything with a fixed set of answers, and write the result into a SharePoint list automatically. Nobody retypes anything, and nothing gets lost in an inbox.
- Stop copying between workbooks. If a monthly report is assembled by pasting branch files together, save those files in one SharePoint folder and use Power Query to combine them. Next month, drop in the new files and press Refresh.
- File and log email attachments automatically. A flow can watch a shared mailbox such as orders@ or accounts@, save each attachment into the right folder and add a row to a list with the sender, date and subject. See 5 Business Processes You Should Automate Today for more starting points.
- Make bad data impossible. Use choice columns, required fields, number and date formats, and lookups to a master list of customers or products. Free text is where “J. Smith”, “John Smith” and “Smith J” become three different people.
- Read documents with care. Tools exist that extract fields from invoices, forms and receipts, including Microsoft’s AI Builder and the import features in most accounting packages. Treat the result as a draft: a person should check amounts, supplier names and especially bank details before anything is paid. Changed banking details on an invoice are a classic fraud signal.
Fix the Process Before the Tool.
Software cannot rescue a process that nobody has agreed on. Before you build anything, do three things:
- Pick one source of truth. Decide which system holds each type of record, such as customers, suppliers or stock. Everything else reads from it.
- Give every record a unique reference. A customer number or job number stops duplicates and lets systems match records without a human deciding.
- Name an owner. Someone must be responsible for each form, list and flow. When that person leaves, the automation should not stop with them. See our note on flow ownership in the Power Automate guide.
POPIA and Data Capture.
Forms and lists collect personal information: names, ID numbers, addresses, phone numbers, sometimes bank details. POPIA applies to every one of them. Five points to check:
- Accuracy is a legal duty. POPIA requires you to take reasonable steps to make sure personal information is complete, accurate and not misleading (section 16). Fewer retyped fields means fewer errors, so reducing manual entry helps you comply.
- Collect only what you need. A form that asks for an ID number “just in case” creates risk without a purpose. Ask only for what the task requires (section 10, minimality).
- Secure the destination. Restrict who can open the list, the folder and the flow, switch on multi-factor authentication and review access when staff change roles (section 19). Our MFA guide explains why this is the baseline.
- Know where copies end up. Form responses, exported spreadsheets and flow run histories can all hold personal information. Decide how long you keep each and who deletes it, in line with POPIA’s limits on retention (section 14).
- Keep a person in charge of significant decisions. Automation may collect and route information, but a decision with legal or similarly significant consequences for someone should not rest solely on automated processing (section 71).
Our POPIA compliance checklist shows how these duties fit into a wider review.
A Simple Plan to Start.
- Find the job. Ask each team what they retype most often. Pick the one that is frequent, boring and low-risk.
- Measure it. Time how long it takes in a normal week and count the errors you find. Without a baseline you cannot show the win.
- Pilot it. Build the form, list and flow with test data, run it beside the manual process for a week or two, and compare the results.
- Switch over and review. Retire the old method, add a failure notification so a broken flow is noticed, and look again in a month.
When to Call for Help.
You can build a form and a list yourself. Bring in a specialist when the data involves money or sensitive personal information, when it has to flow into accounting, payroll or CRM software, or when the business has come to depend on it. Our business automation service maps the process, builds and tests it and documents it, and our managed IT service looks after the accounts, permissions and security that it relies on. For a one-page summary to share with your team, download our free guide, 5 Business Processes to Automate This Quarter.
Book a Free Workflow Review.
Tell us which job your team retypes most. We will check what your Microsoft 365 plan already includes, show you what can be automated and give you a clear scope and quote.
Contact Us
← Back to Blog