Time is Money: Don’t Spend Valuable Time Inputting Data into QuickBooks
Diane Glover
Jun 18, 2014

Do you get valuable monthly data from vendors and banking partners? How do you process that information to run your business? Do you have someone manually input all of those records into QuickBooks?
If so, here is a solution for you! Recently a client came to us with a problem. Each month they received large amounts of data from one of their vendors in an excel spreadsheet. An employee was then spending 5-10 hours a week to manually input that data into QuickBooks. On top of that, they were then spending a lot of time reconciling all of those inputs for errors that were made in the manual entry process.
The Solution:
When we were approached for a possible solution, we developed a solution that resulted in significant time savings and better overall record keeping.
The first step was to identify the proper third party software that would import the data the client was being provided from their vendor. QuickBooks has several third party add-on solutions to help import the data. Our team has worked with the third party software programs and we quickly identified the appropriate software for their situation.
Once identified, the next step was to make changes to the layout provided by the vendor to an acceptable format for the import software. Microsoft Excel is a great tool for manipulating data into a format that is compatible with the client needs. Our team developed an excel file with built in macro’s that properly formatted the data.
The third step was to link the re-formatted file with the import software. Now, what once took hours and hours of manual time is done in minutes. In addition, there are no longer concerns about manual input errors because everything is input electronically in seconds.
The Bottom Line Result
The Client’s initial solution was to hire additional accounting personnel, costing them a new salary and benefits. With the help of the Kirsch team, our client saved thousands of dollars and gained valuable time by re-purposing current staff to work on more valuable projects than data entry.
How Do I Implement?
If your team is spending time on manually entering external data from a vendor or banking partner, there is a better solution. Contact your bank and learn more about the process of downloading bank reconciliations, follow our steps to save valuable time or give our office a call at(513)858-6040 and we will share our experience to help you explore the options.

About The Author
As the Manager of Practice Growth, Diane focuses on the market awareness and growth of Kirsch CPA Group…
Tags
Sign Up for Email Updates
Related Articles






Education Benefits Can Help You Recruit and Retain Smart Employees
- 05-26-22
- Kirsch CPA Group









Ensure Your Construction Accounting System Has the Right Features
- 05-12-22
- Kirsch CPA Group


















John Kirsch Named to Greater Butler and Warren Counties Business Hall of Fame
- 03-25-22
- Diane Glover






Manufacturers Need to Act Soon to Take Advantage of 100% First-year Bonus Depreciation
- 03-17-22
- Kirsch CPA Group



























Commission Fraud: Salespeople Getting Paid More Than They’ve Earned
- 02-04-22
- Kirsch CPA Group
















































Consider a New Approach to Meeting Your Business Real Estate Need
- 09-17-21
- Kirsch CPA Group
























Beware: Teleworking Arrangements May Cause State Tax Withholding Issues
- 08-18-21
- Kirsch CPA Group
























5 Common Construction Accounting Risks — and How to Address Them
- 07-07-21
- Kirsch CPA Group


















Supreme Court Finds No Standing to Challenge a Provision of the ACA
- 06-24-21
- Kirsch CPA Group






Labor Shortage: Unlock Solutions by Evaluating Your Employment Value Proposition
- 06-09-21
- Kirsch CPA Group









Material Participation Standard is the Key to Unlocking LLC Tax Losses
- 05-27-21
- Kirsch CPA Group









Know Your Legal Obligations Under the Americans with Disabilities Act
- 05-13-21
- Kirsch CPA Group
























PPP Loan Not Forgiven? There’s a Safe Harbor for Deducting Expenses
- 12-03-20
- Kirsch CPA Group












What You Need to Know About the Deferral of Payroll Tax Obligations
- 09-15-20
- Kirsch CPA Group


















PPP Loan Forgiveness – Significant Borrower Friendly Changes on the Horizon
- 06-04-20
- John Kirsch





















Tax Filing Deadline Remains April 15 – Payment Due Extended to July 15
- 03-19-20
- John Kirsch








































































Prepare to Receive a Social Security Administration No-Match Letter
- 10-15-19
- Kirsch CPA Group





















IRS Announces Changes for Personal Use of Employer-Provided Vehicles
- 06-10-19
- Diane Glover






























Watch Out for these Tax Issues When Planning for Your Business in 2018
- 06-26-18
- Diane Glover









What Image Does Your Organization Present to Large Contributors?
- 03-15-18
- Kirsch CPA Group



8 strategies to help you adapt to economic down turn without layoffs
- 02-24-18
- Diane Glover













































Remember To Take Required Minimum Distributions at Age 70 1/2 Or Face Penalties
- 02-17-17
- Sue Schloemer








































