California sales tax records: 3 electronic record options

Key takeaways

• Map where your sales records are stored.
• Test whether older files still open.
• Keep a copy of files you give the state.
• Ask outside providers how you can retrieve your records.

Electronic sales records are the invoices, sales reports, and supporting files a business keeps in accounting software, a point-of-sale system, a spreadsheet, or cloud storage instead of on paper. During a California sales tax review, the real question is not whether your records are digital. It is whether the state can reach them, read them, and rely on them.

The California Department of Tax and Fee Administration (CDTFA) explains how electronic records are handled in Regulation 1698. That regulation is the main source for this post. This post is general information, not advice about your own business.

This post covers three practical ways to handle electronic sales records. If you run a small business, you may need only one. Larger operations often combine them. The post also explains a related agreement that some businesses ask about, and it offers a simple way to test your records before a review begins.

Start with the access rule

The most useful sentence in the regulation for everyday planning is about access. It says the way the Board is given access to electronic records "may be satisfied through a variety of means that shall take into account a taxpayer's facts and circumstances through consultation with the taxpayer." ( Regulation 1698)

In plain terms, the rule does not name one approved software product, file format, or storage method. The method should fit your business, and the state is expected to talk with you about what fits. That gives you room to choose. It also means you cannot assume the state will accept whatever you already have. Plan ahead, and be ready to explain how your setup works. Think of the access rule as a conversation, not a checklist.

Before you choose an option below, answer four questions:

• Where does each type of sales record live today?
• Who can open, change, or delete those records?
• How quickly could you produce a month or a quarter of invoices in a readable form?
• Who would answer the state's questions if the person who set up the system were unavailable?

Your answers will show which option fits best. Many businesses end up using more than one.

Option 1: Keep your own system and provide access

The first option is to keep electronic sales records in your own system and make sure you can give the state access when it asks. The system might be accounting software you run yourself, a point-of-sale system with export features, an invoicing tool, or a set of organized spreadsheets.

This option gives you the most control. You decide where the records sit, who can edit them, and how backups are made. The trade-off is responsibility. You must keep the system working, keep older files readable after software updates, and produce records on request.

Some practical steps:

• Map your records. List each system that holds sales invoices, its export tools, and the people who can log in. A short list is enough to start.
• Keep files readable. A file that opens only in a program you no longer pay for may be useless when someone asks for it. Confirm that older files still open, not just this month's.
• Build a clear index. Organize invoices by period and label files consistently, so you can find a month of sales without searching every folder.
• Test an export. Export a sample period and confirm that it opens, includes the fields you need, and matches your sales reports. Repeat this on a regular schedule, not only when a request arrives.
• Limit who can change records. Use user accounts and permissions so changes are traceable, and note who made significant changes and why.

Make sure more than one person knows how to find and export records. A review may start with a request for specific documents, and delays frustrate everyone involved.

Switching systems deserves special care. When a business replaces its invoicing tool or moves to a new accounting platform, old records do not always come along in a readable form. Before you retire a system, export a full period, confirm the export opens, and store that copy somewhere you control. Then compare a few invoices in the old system with the same invoices in the new one. Differences in tax fields, customer details, or dates are much easier to explain during a migration than during a review.

For related checks, see electronic invoice records.

Option 2: Create files for the Board's use

The second option is to create separate files for the state. The regulation says that "In conjunction with meeting the requirements of subdivision (c), a taxpayer may create files solely for the use of the Board." ( Regulation 1698)

The phrase "in conjunction with" is the key. These files work alongside the records you already keep. They are not a replacement, and they should not be the only copy of anything. The regulation ties this option to subdivision (c), so read that part of the page before you rely on this approach.

In practice, a review file is an export from your system into a standard, readable format, with clear file names and a short cover sheet. The cover sheet might list the period covered, the source system, the date of the export, and the person who prepared it. The cover sheet also helps the reviewer, who can see at a glance what they are looking at and where it came from. Keep a copy of exactly what you gave the state.

A few habits make these files easier to use:

• Use one file for each period, with the period in the file name.
• Keep the same column layout each time, so files are easy to compare from one period to the next.
• Consider including the invoice number, date, customer name or ID, taxable amount, and tax charged, so a reviewer can trace each sale to its source.
• Do not edit a file after you send it. If something is wrong, create a corrected version and explain the change in writing.

That last habit matters more than it might seem. A North Carolina statute on returns is blunt about incomplete submissions: "Returns that do not contain the required information will not be accepted." ( North Carolina General Assembly) It adds that "When an unacceptable return is submitted, the Secretary will require a corrected return to be filed." ( North Carolina General Assembly) North Carolina's rules are not California's; treat this as a reminder to check your files, not a California requirement. For your own files, checking that each package is complete before it leaves your hands is a useful habit.

Avoid one common mistake: sending a summary report and calling it the records. A summary can help, but it may not show the detail a reviewer needs to trace individual sales back to original invoices.

Keep a simple log of every set of files you prepare: the period covered, the date you created the files, each file name, and the date you sent it. If the state asks a follow-up question, the log shows exactly which version the reviewer already has. Bookkeepers who prepare files for several clients will find the log especially useful when two versions of a file circulate.

Option 3: Hand custody to a third party

The third option is to use an outside provider. The regulation says that "A taxpayer may contract with a third party to provide custodial or management services of the records." ( Regulation 1698)

Outside providers can include a bookkeeping firm, a cloud accounting service, or a storage company that holds your files. Some businesses choose this route because it moves maintenance and backups to someone whose job is to handle them.

Using a third party still means you need to check how your records are handled. Before you sign, ask the provider direct questions:

• Where are my records stored, and can I get them back in a readable form?
• Who at the provider can see or change my records?
• How are records backed up, and how would I learn that a backup failed?
• What happens to my records if I end the contract?
• Who will help me respond if the state asks for records?

Get the answers in writing. Keep your own copy of key records, or at least a current export, so you are not dependent on one provider for everything. The provider is part of your process, so treat its answers as part of your own procedures. If a contract term is unclear, have a lawyer or tax professional review it before you sign.

Think about the end of the relationship before it begins. Can you download every record in a readable format? Does the provider charge to export your data? How long would a move to someone else take? A provider that answers these clearly is easier to trust. One that cannot is a warning sign.

Decide too who on your side is the day-to-day contact. When the state asks a question, someone in your business should reach the provider quickly and understand what it can produce.

A note on record retention limitation agreements

A separate part of the regulation may matter to businesses that want a different arrangement. The Board can enter into a record retention limitation agreement with a taxpayer. The regulation puts it this way: "The Board has the authority to enter into or revoke a record retention limitation agreement with the taxpayer to modify or waive any of the specific requirements in this regulation." ( Regulation 1698)

This is an agreement, not a default setting, so you cannot assume you have one. Because the Board can revoke it, the terms matter. The regulation also says that "A taxpayer's record retention practices shall be subject to evaluation by the Board when a record retention limitation agreement exists." ( Regulation 1698)

The regulation also allows the Board to test electronic records kept under such an agreement. See "Test your records before a review" for those tests; the same checks help even if you never sign one.

If you think an agreement might suit your business, start by asking the CDTFA how the process works. Get the terms in writing, and keep a copy with your other tax records.

What a review may look like

Every review is different, so the best preparation is understanding its general shape. A review may involve a request for sales records covering particular periods, questions about how your accounting or invoicing system works, and a look at how records are stored, backed up, and changed over time.

The access language suggests the state will consider your particular setup rather than a single standard format. That is why the four questions above matter. If you can explain where records live, who controls them, and how you produce them, you are in a much stronger position than if you are learning those answers mid-review.

Sales to exempt buyers bring their own paperwork. New York's tax department describes the protection a seller gets from good documentation: "A properly completed exemption certificate accepted in good faith protects the seller from liability for the sales tax not collected from the purchaser." ( New York State Department of Taxation and Finance) The same guidance shows the other side of that protection: "Otherwise, the distributor could be held liable for the tax." ( New York State Department of Taxation and Finance) New York's rules are not California's, but a sensible habit applies anywhere. Store exemption paperwork alongside the sales it supports, in the same system you use for sales records.

For related paperwork checks, see electronic resale certificates.

It also helps to keep your tax paperwork in one place. A simple folder, with a short index pointing to each system and provider, can save hours when someone asks a basic question. Update it whenever your systems change.

If you are a bookkeeper, you are often the bridge between the owner and the records. You may know the software best, and you may answer the first round of questions. Write down how you pull reports, which filters you apply, and any manual adjustments you make. A reviewer who asks how a number was calculated gets a clearer answer from a written procedure than from memory. Share that procedure with the owner so the business does not depend on one person's knowledge.

Test your records before a review

The regulation names four things the Board may test on electronic records kept under a record retention limitation agreement: "authenticity, readability, completeness, and integrity." ( Regulation 1698) Even without such an agreement, these four ideas make a useful checklist for any electronic sales records:

• Authenticity: Can you show that the records are what they claim to be, and that they came from the system and period you say they did?
• Readability: Can you open and read the records without special help from a former employee or a discontinued program?
• Completeness: Does the set include every record for the period? Look for gaps in invoice numbers and missing months or customers.
• Integrity: Can you show that the records have not changed in unexpected ways since they were created?

Authenticity and integrity are about trust in the records. Readability and completeness are about whether anyone can use them. Run this test on a sample period on a regular schedule, and also before you expect a review. Note what you tested, what you found, and what you fixed.

When you choose a sample, pick a period that reflects normal activity, and include invoices from its start, middle, and end. Include at least one unusual sale, such as a refund, a sale to an out-of-state customer, or a discounted sale, because those are the transactions most likely to expose a gap in your process. Trace each sampled invoice from the source system through your export and into your sales reports. If the numbers do not match at any step, you have found something to explain or fix before a reviewer does.

If a test fails, do not hide the problem. Note what went wrong, fix the cause if you can, and keep a record of the fix. A documented correction is far easier to explain than a gap you cannot account for.

Illustrative example: Find a missing invoice

Check the export filters, repeat the export, and compare it with the source records. An export containing 20 invoices still needs checks for readability and matching details; the count alone does not prove accuracy.

A simple plan to get started

1. This week: List every system that holds sales records, including any outside providers.
2. This month: Choose the option, or combination of options, that matches your answers to the four questions.
3. Before your next period closes: Run a test export and assess it against the four tests above.
4. If you use a third party: Request written answers to the provider questions, and keep a current copy of your records.
5. If you are unsure about a term or an agreement: Ask the CDTFA how it applies, and write down the answer.

Keep the plan short enough that someone can follow it on a busy day. The goal is not a perfect system. It is a system you understand, can explain, and can show working when it matters. Assign each step to a named person, and revisit the plan when your software changes, you add a provider, or your business grows.

Today, open an older invoice and confirm that you can export and read it.

Questions about electronic records

Can I create separate files for the Board?

Yes, alongside meeting subdivision (c), you may create files solely for the Board's use. Keep the underlying records and a copy of the files you supply.

Is a record retention limitation agreement automatic?

No, it is an agreement the Board may enter into or revoke. Ask the CDTFA how the process applies to your business before relying on it.