File Maintenance, Security, and Error Correction

Why File Maintenance and Security Matter

A bookkeeping file is a legal business record. Errors left uncorrected distort financial statements, trigger tax problems, and erode stakeholder trust. Unauthorized access can lead to fraud, accidental deletions, or privacy violations. QuickBooks Online (QBO) gives you built-in tools to catch mistakes, restrict who can do what, and protect your data through backups. Mastering these tools is a core competency tested on the QuickBooks Certified User exam and expected by every employer.

The Audit Log: Your Error-Detection Engine

QBO automatically records every action taken in a company file in the Audit Log (Gear icon → Audit Log). Each entry shows the date, time, user, event type, and the before/after values of any changed transaction. You cannot delete or alter audit log entries — this protects the integrity of the record.

When you suspect an error, start here:

1. Filter by date range and event type (e.g., "Deleted," "Changed").

2. Look for unusual patterns — a transaction modified multiple times, activity at odd hours, or entries made by a user who should not have that access.

3. Click View on any line to open the full detail, including every field that changed.

Transaction History: Tracing a Single Document

For a specific invoice, bill, or payment, open the transaction, then click More → Transaction History (in QBO the path may show as More → Audit History depending on your version). This gives you a timeline of every edit to that one document — who created it, who changed it, and what the amounts were at each stage. Use this when the Audit Log points you to a suspicious transaction and you want the full story.

Five Common Errors and How to Correct Them

1. Duplicated invoice. Two invoices exist for the same customer, same date, same amount. Locate the duplicate using the Audit Log (look for two "Added" events close together). Open the duplicate, verify it is truly a copy, then click More → Void or Delete. Voiding keeps the transaction visible with a $0 balance; deleting removes it. For audit clarity, void rather than delete whenever possible.

2. Wrong account on a transaction. An expense was coded to the wrong account (e.g., office supplies posted to repairs). Open the transaction, change the account field to the correct account, and save. The Audit Log will record the correction automatically.

3. Voided check re-entered as a new check. Someone voided a check and then created a brand-new check for the same payee and amount, effectively doubling the expense. Identify both in Transaction History. Delete or void the incorrectly re-entered check and confirm the original void is still in place.

4. Undeposited Funds backlog. Payments sitting in the Undeposited Funds account that were never moved to the bank account cause the balance sheet to overstate assets and your bank reconciliation to fail. Go to + New → Bank Deposit, select the correct bank account, choose the pending payments, and complete the deposit. Match the deposit date to the actual bank deposit date.

5. Misclassified expense. An owner's personal expense was recorded as a business expense. Use the Audit Log to find it, open the transaction, and recode it to the correct equity or drawing account (e.g., Owner's Draw / Distributions), or delete it if it should not be in the file at all.

Setting Up a Restricted User Role

Controlling access is a security best practice and an internal control requirement. In QBO, go to Gear → Manage Users → Add User. Choose a role:

• Standard User — you define what areas they can access (sales, expenses, reports, payroll).
• Reports Only — read-only access to reports, no ability to create or edit transactions.
• Time Tracking Only — limited to entering time.

For a view-only role with no payroll access: select Standard User, then in the access settings grant Reports: View only and turn off all payroll permissions. After saving, log in as that user (use a private/incognito browser window or a separate device) and attempt a restricted action — for example, trying to run payroll or edit a transaction. QBO will display a permission-denied message confirming the restriction is working. Document what you tested and the result.

Security reminders: Never share Admin credentials. Use strong, unique passwords. Enable multi-factor authentication on QBO Admin accounts. Treat login credentials like keys to a cash drawer — they control access to sensitive financial data.

Backup and Restore

QuickBooks Desktop (.QBB files): Go to File → Back Up Company → Create Local Backup. Save the .QBB file to a secure location (external drive or cloud storage). To restore, go to File → Open or Restore Company → Restore a Backup Copy, select the .QBB file, and follow the prompts. After restoring, run the Trial Balance (Reports → Trial Balance) and compare totals to your pre-backup figures — they must match exactly.

QuickBooks Online: QBO data is stored in Intuit's cloud, so there is no .QBB file. Instead, use QBO's Export Data feature (Gear → Export Data) to download a summary export, or use a third-party backup tool approved for QBO. For classroom purposes, your instructor may provide a Desktop company file for the full backup-restore cycle.

Always verify the restore by comparing the Trial Balance before and after. A mismatch means the backup file is corrupted or an incomplete restore occurred — run the restore again from the original backup.

Summary

File maintenance is not optional housekeeping — it is a professional obligation. Use the Audit Log and Transaction History to detect and document errors before correcting them. Restrict user access to match job duties. Back up regularly and always verify the restore. These habits protect the business, satisfy auditors, and demonstrate the competence employers expect from a certified bookkeeper.