Sunday, January 26, 2020

Turn Key Office Services: Consolidated Reporting

Turn Key Office can provide custom solutions for correlating and reporting financial data among multiple independent QuickBooks files. QuickBooks Enterprise provides some limited financial reports that will consolidate across separate entities, but those reports are “pre-canned” and may not provide the specific information or filter capability you need.

We have experience deploying custom software solutions to provide specific reports unique to your portfolio of businesses. Reports that can present meaningful management data across thousands of available data fields and unlimited numbers of QuickBooks files.

Please contact us for a complimentary 1 hour consultation and a quotation for your custom reporting project.

Thursday, January 23, 2020

Job Costing for Professional Service Firms | QuickBooks Enterprise

Get high-level insights—like which projects bring in the most revenue—at a glance. Integration with TSheets makes for easy time tracking for your employees—no matter where they are. Special reports like billed vs. unbilled labor help ensure you’re re-billing every hour to clients and nothing slips through the cracks. Enterprise with job costing for professional service firms helps you make better decisions, get paid faster, and grow your business.

Monday, January 20, 2020

KOL Foods, Inc Case Study

At Turn Key Office, we delight in using QuickBooks as a component tool of a more comprehensive business solution. We take pride in understanding our clients’ unique business challenges and in implementing solutions that often extend well beyond the basic capabilities of QuickBooks. The case studies below illustrate some of these challenges and solutions for vastly different industries.

Company : KOL Foods, Inc

Website :

History : KOL Foods formed in 2007 with a groundbreaking effort to produce the first kosher, organically raised, local, grass-fed meat. Founder and CEO, Devora Kimelman-Block, established a three-pronged partnership with a synagogue in Washington, DC, a slaughterhouse and a local farmer to produce the meat. Scores of kosher consumers, who until then could only buy kosher meat raised in confinement, were eager for this product. In just its second offering, the company generated sales for more than 2400 pounds of beef though a single email. Jews from 14 different area synagogues, ranging from Reform to Conservative to Orthodox, purchased this meat.

Today KOL Foods ships to the entire continental United States and produces the only domestic, 100% grass-fed, kosher beef and the only organic-fed, pastured, kosher chicken and duck in the United States. Each and every day, they strive to be the most transparent kosher meat company on the planet. That way, customers don’t have to choose between eating according to their values and keeping kosher.

Business Challenge : KOL Foods quickly outgrew QuickBooks Premier as they added scores of new clients, products to their custom-designed website and as word-of-mouth spread.

In addition, her current bookkeeper used QuickBooks Premier, so Ms. Kimelman-Block had no real-time access to payables to predict cash flow and manage her vendor payments. Data files were transferred from the bookkeeper, to Ms. Kimelman-Block and then to the CPA and back. Cash flow management was not available. Vendor payments were completed with hand-written checks, and then sent to the bookkeeping service for entry.

Most importantly, there was no integration between their custom designed website order system and QuickBooks, so Ms. Kimelman-Block had to rely on insufficient and untimely data to make decisions about inventory to meet her clients’ needs. Her prior bookkeeping service hand-entered every order from the website into QuickBooks. With orders as high as 50,000 items in a single month, her current bookkeeping procedures left her books six months in arrears.

She reached out to Turn Key Office LLC for help.

Solution : Based on the growth of her business, we converted her data to QuickBooks Enterprise on our back office server and setup Intuit Bill Pay.

We provided a dedicated payables email box for her vendors so that our back office team could post all of her payables and attach the backup for each vendor bill. Ms. Kimelman-Block retained sole control of when, whether and how much each vendor was paid with a clear view of available and committed cash on hand. As an added benefit, she could continue to manage her payables even while travel requirements took her away from home.

Most importantly, we devised a workflow and a tool using off-the-shelf software where weekly sales orders and merchant sales are imported seamlessly into QuickBooks. The data that used to take months to hand-enter is now completed in the span of a few hours from start to finish. Ms. Kimelman-Block has full real-time access to her books, the CPA also has access, and she has full control of all payables.

Conclusion : The critical reports she needs to manage her business effectively are available within a day or two of closing the month. The procedures are accurate, consistent and timely. Ms. Kimelman-Block can turn her attention back to serving her customers and growing her business.

Friday, January 17, 2020

How to Add Customers to QuickBooks

Adding your customers to QuickBooks makes it easier for you to invoice them and see who owes you money. Let’s go over the customers list, and look at two ways to add customers to QuickBooks.

Tuesday, January 14, 2020

7 Tips to Help You Become More Goal-Oriented | Brian Tracy

Are you writing down your goals for the new year? WRITTEN goals are 3 times more likely to be accomplished than unwritten goals - who knew? Discover the simple seven-step formula you can use to start writing down your goals and achieve success today!

Saturday, January 11, 2020

How to Get Paid with QuickBooks Payments

Work takes time, but getting paid shouldn't. Get paid faster with QuickBooks Payments and accept credit cards, debit cards, and ACH bank transfers.

Wednesday, January 8, 2020

Where Focus Goes, Energy Flows.

According Richard Janes, if you want to be successful, you have to get laser-focused on what you love. Watch the full video to learn more

Sunday, January 5, 2020

How to Use Journal Entries in QuickBooks Online

This video will show you how to make and record a journal entry in QuickBooks Online. You should only create journal entries if you are confident with accounting or following the advice of your accountant.

Most transactions don’t need a journal entry, but you might need to use them for things like correcting errors or summarizing the depreciation of an asset.

Thursday, January 2, 2020

How to Develop a Clear Vision for 2020 | Brian Tracy

Only a leader can think about the future and plan for the future each day, and this is even more evident when heading into a new decade. Watch today's video to develop a clear and exciting vision for your future, and how to plan for a success-filled 2020.