Protecting Accounting Software Data in the Business Office

It is the second day of month end. The general ledger is open, payables are half posted, and the business office manager sees an error on the screen she has never seen before. The accounting program will not start. Everything that was done this week lives in that program.

For many facilities the accounting data is the most important data they own that is not clinical. Payables, payroll entries, the general ledger and reports to owners all depend on it. Business office managers do not have to be technical to ask good questions about it.

Find out where the data actually sits

Accounting software stores its data in a few different ways, and the protection you need depends on which one you have.

On a server in the building. The data lives in a database or company files on a computer in a closet or office. If that machine fails, so does the data unless it is backed up elsewhere.

On one person's computer. Small offices sometimes keep the company file on the office manager's desktop, with others reaching it over the network. That makes a single computer a single point of failure.

In a vendor's cloud. The vendor hosts the data. This lowers some risks, though you should still know what they back up and how you get your own data out.

In spreadsheets alongside the main program. Month-end schedules, bank reconciliations and accrual workpapers often live in Excel files in a shared folder. They matter as much as the ledger.

Also locate the attachments: scanned invoices, approvals and supporting reports. These are often stored separately from the ledger itself.

How accounting data gets lost

The causes are rarely dramatic. More often they are ordinary.

A hard drive or server fails and the only backup is old, or has never been tested

A software update or database repair goes wrong

Someone deletes or overwrites a file, or posts a batch to the wrong period

Ransomware locks the files and the backups on the same network

A person leaves who was the only one who knew where the data was kept

The vendor changes plans or ends a product, and access to old data becomes difficult

What to confirm with IT

Bring these questions to your IT provider or the person who manages the software. Write down the answers.

Where exactly is the accounting data stored, including the attachments and the spreadsheets?

How often is it backed up, and is it more than once per day during month end?

Where does the backup copy go, and is at least one copy kept away from the building and away from the main network?

Is the backup encrypted?

When was the last time someone restored it as a test, and did the restored data open correctly?

How far back can we restore, and can we go back to a specific day?

How long would it take to get running if the machine died today?

Who besides me knows how to reach the data and the backups?

If the answer to the restore question is "never," that is the first thing to fix.

Protect the data day to day

A few habits make a real difference.

Close each period carefully and save a copy of the closed period's reports as files, in a separate location.

Use individual logins with the least access each person needs. The person who enters invoices should not also approve payments.

Keep a written log of backups, even a simple one, and look at it.

Do not leave the data on a laptop that travels or sits unlocked.

Plan for the bad day. Know whom you would call, and know what you could do on paper for a few days, such as a manual check run for urgent vendors.

Protect the money side too

Accounting systems are also where fraud lands. Fake invoices, changed vendor bank details and forged payment requests often arrive by email. A rule that anyone changing a vendor's banking information must be confirmed by phone to a known number is simple and powerful. Talk with your IT provider about sign-in protection and who can approve payments.

How we can help

UnityCare IT can find where your accounting data really lives, set up backups that include the attachments and spreadsheets, keep a copy away from the building, and test a restore with you before month end rather than during it. We can also tighten access to the accounting system and work with your vendor when something needs fixing.

Related service

Security monitoring, HIPAA safeguards, backups and staff training for healthcare and small businesses.

Related articles

Keep reading

Contact UnityCare Technologies

Call or text: 405-285-3845

New customers: start@unitycareit.com

Existing customers: support@unitycareit.com

Service area: based in Edmond, Oklahoma, serving Oklahoma, Texas and Kansas

Hours: Mon–Fri 8 AM–5 PM CT; 24/7 after-hours support