Accounting Frontier Blog

Posts by Paul Kirkendall:

Top 5 Essential KPIs for Interior Design Businesses

Top 5 Essential KPIs for Interior Design Businesses

Key Performance Indicators (KPIs) play a crucial role in evaluating the financial and operational health of any organization. While some KPIs are universally applicable, others are industry-specific. In this article, we will delve into the top five KPIs that hold significant importance for the interior design industry. By monitoring these metrics, design firms can gain valuable insights and make informed decisions to enhance their overall performance.

Excel Uploads

Excel Uploads

There will often be times where a software may not connect to your accounting software, but you can still automate the entry of data through an excel upload template. Bookkeeping automation is about getting your data entered as quickly and accurately as possible so that you can analyze your data and use it to drive your business’ performance. You should always be thinking of ways to streamline and improve processes. Excel upload templates essentially act as bridge connection on your wagon wheel when a direct connection doesn’t exist. In accounting softwares like Xero or QuickBooks Online, you can upload contact data like vendor or customer information, but you are also able to upload transaction data for bills, invoices, or credits. Xero stands out in this area due to its open platform and the fact that excel data importing is an included function of the software (see Why Xero instead of QuickBooks link). QuickBooks allows transaction uploads, but it’s provided through other vendors who charge for the service.  

Project Accounting Software Considerations

Project Accounting Software Considerations

We’ve spent time discussing the structure of bookkeeping and the necessary tools to get a complete and accurate product. In this section, we’re turning our focus to a second layer of tracking called project accounting. This adds another level of complexity to the accounting process, but with the right system, it can be done efficiently and effectively. Often times the success or failure of a project-based business is determined by how well they can execute this process. 

Purchase Order Systems

Purchase Order Systems

Most businesses have a disjointed process for submitting, reviewing, and approving purchase requests. Many don’t have a process at all. If you’ve spent anytime using a spreadsheet to track purchase requests, you know firsthand how difficult, time consuming, and frustrating this process can be. A poor functioning purchasing system leads to a disconnect between your company’s financial goals and what actually gets spent. There is a solution though and it functions within the wagon wheel of your automated bookkeeping system! A simple purchase request system that is integrated with your accounting software will bring enhanced financial controls to your business, align your actual spending with your budget, and improve communication between accounting and operations.

Document Hub & Bill Entry

Document Hub & Bill Entry

A core bookkeeping automation tool is a document collection / bill entry software.  This type of software is incredibly helpful and serves several important functions.  First, it acts as a central document collection hub for your business.  Employees can upload bills and receipts directly to the application via email or by taking a picture of the bill or receipt on their mobile phone. In addition, anyone outside your organization can upload bills by sending a pdf attachment from an email.  This effectively decentralizes the entry of bill data by getting it into your document hub from multiple sources.  The second function of this type of software is it reads the scanned copy of the bill and pulls important data from the document such as vendor name, invoice date, due date, invoice number, and amount and then enters the data into fields for your review.  After quickly reviewing the data, you publish both the bill data to your accounting software and a pdf copy of the actual invoice to the transaction in your accounting software.  You can set it up so that no bill goes into your system without your review or have bills automatically enter the system once they are uploaded after you become more comfortable with how it works. The software also remembers previous entries so if you use a vendor frequently, it will pull all the data from the current bill and then remember the general ledger account you assigned to that vendor previously. 

Bill Payment Platforms

Bill Payment Platforms

Most people are familiar with the online bill pay feature included with their bank, but did you know there are bill payment platforms specially designed for small businesses?  These systems not only print and mail checks for you, but they can do direct electronic payments with your vendors as well. The banking profile of the vendor can be managed by the vendor without you ever being involved with it. Wires, domestic and international, can all be handled within this system. And perhaps the best feature is the interaction with the bill payment system and your accounting system. Bills automatically sync between both systems for a seamless experience. This drastically reduces the amount of time for data entry. In this article, we’re going to discuss why you should consider moving away from hand-written checks and move toward a bill payment platform.

Budget Best Practices

Budget Best Practices

In its simplest terms, a budget is a realistic estimate of future revenues and expenses. This is an important exercise for a business to do at least annually just prior to the new year. Budgets should include your normal operating revenues and expenses, but also factor in capital improvements, staff additions, infrastructure investments (like software or equipment), and other long-term purchases. A great budget allows the team to plan future expenditures that align with the mission and vision of the organization.