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

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. A client recently 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 contact us 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















Tax Treatment of Debt Forgiveness: Watch Out for Tax Bills Delivered COD
- 01-18-23
- Kirsch CPA Group












Manufacturers: Be Aware of These 3 Business Tax Provisions Currently in Limbo
- 01-18-23
- Kirsch CPA Group



The Tax Deductible Mileage Rate for Business Driving Increases for 2023
- 01-04-23
- Kirsch CPA Group









Succession Planning Considerations for Construction Business Owners
- 12-14-22
- Kirsch CPA Group






Prevent Fraud at Your Construction Company With a Holistic Approach
- 11-30-22
- Kirsch CPA Group









Manufacturers Must Act Now to Maximize Depreciation-Related Tax Breaks for 2022
- 11-09-22
- Kirsch CPA Group



It’s Time for Businesses to Rethink Their Working Capital Practices
- 11-09-22
- Kirsch CPA Group









Social Security Wage Base and Earnings Test Amounts Increase in 2023
- 10-27-22
- Kirsch CPA Group



New Law Enhances Payroll Tax Break for Small Manufacturers’ Research Expenses
- 10-13-22
- Kirsch CPA Group







































How Buy-Sell Agreements Factor into Business Owners’ Estate Plans
- 09-14-22
- Kirsch CPA Group









SALT Cap Workaround Law Could Save Ohio Business Owners Over $100 Million
- 08-31-22
- Kirsch CPA Group
























How Manufacturing Companies Can Benefit from the Section 179 Expensing Deduction
- 08-04-22
- Kirsch CPA Group



























Could the Work Opportunity Tax Credit Help Your Construction Company?
- 06-23-22
- Kirsch CPA Group






Good News: IRS Boosts Standard Mileage Rates for Second Half of 2022
- 06-23-22
- Kirsch CPA Group
























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








































