Every business has customers, and while all customers are important, most entrepreneurs will agree that some customers are more important than others. This may be due to the amount of revenue the customer brings in, their ability to refer new clients to you, the interesting challenges of the customer, or another factor. It makes sense to identify these clients so you can spend more time with them or at least acknowledge them in some way.
How do you find out which clients have generated the most revenue with you? If you store customer data in your accounting system, you can run a report to generate the data you need. In QuickBooks, the report is called the Income by Customer Summary Report. In Xero, it’s called Income by Contact. If you do not store customer data in your accounting system, you may be able to generate a report from your billing system, shopping cart, or point-of-sale system.
The reports look like this: each row holds the customer name and the Income column holds total revenue by the customer. If your system allows you to sort the revenue field, do this in descending order. If not, you can export the data to Excel and sort it in Excel.
Once you’ve sorted the data, the answer is right in front of you. Your top customers based on revenue will show in order. These are the customers you may want to consider spending more time with. Schedule periodic lunches with them, give them a call on a regular basis, and send them a gift or thank you note once in a while. The report helps you organize your connection points with your top clients so you don’t miss an opportunity or forget to reach out to an important customer.
Run this report on a regular basis so that you’re focused on nurturing the most important relationships in your business. You can also look at trends to see if you’re losing revenue over time or gaining revenue with new clients. You can reach out to clients that are spending less with you to try to save the relationship before it’s too late. And you can get to know new clients that are growing with you so that you can grab even more business.
Make this report a regular activity in your business to stay close to what your customers are doing with you.
Setting customer expectations in your business is essential to gain the trust of your customers, avoid conflicts, and maintain a high level of customer service. One way to set customer expectations is to clearly state policies that are customer-facing. Many of these are accounting policies that we can help you with. The following policies are ones that every business should clearly publish.
When customers purchase your products or service and don’t get what they expect, what is their recourse? Your refund policy should clearly state which products and services are refundable. Do customers need to physically return the product in-store or via shipping? What if it’s a service? Are they refunded in cash or credit card? Or is it a store credit? Is there a deadline for refunds?
All of these questions should clearly be outlined in your refund policy. Your website is a great place to publish it.
If your customer has a complaint, how should they submit it? Is there a hotline to call, a suggestion box, or a form to fill out? If your business and employees are licensed, is there a government agency to write? A notice should be posted on your website and in your physical location describing where to submit complaints.
Not all businesses need a shipping policy, but you do if you ship physical goods to a customer location. What is the cost of shipping? What is the expected delivery time? A shipping policy explains this as well as what can go wrong: If the item was never received, what should one do? Must you sign for a shipment? If you return a shipment, who pays the shipping? If an item is received damaged, how do you file a claim?
While not a policy this customer communication needs to be clearly posted. What forms of payment will you take? If you take a check, what ID does the customer need to show? Do you take some of the newer forms of payment such as Apple Pay or cryptocurrencies? How do gift cards work?
If a customer doesn’t pay their bills on time, they should know what to expect. Will interest be charged? Will the account be sent for collections? Will someone break the customers’ legs? Will future purchases be cancelled or require a C.O.D. (cash on delivery) payment?
You might not think of your accountant when it comes to writing these policies, but you should; we can help. A good accountant can help you craft these customer service policies so that your communications and expectations with customers are better than ever.
Artificial intelligence (AI) has arrived in the accounting profession in a big way. The good news is it’s streamlining accounting tasks, finding patterns in data you can take action on, and generally making things better. Here are just a few places we’re seeing AI and machine learning impact accounting.
Most systems have incorporated some form of machine learning into transaction coding. When bank feeds are imported, each transaction needs to be coded to add the account code in the chart of accounts. Class, tracking codes, and other custom data may need to be added as well. Rules can be set so that the accounting application can pre-code the transactions; in this case the accountant simply approves or corrects the entry.
It starts with a picture of a receipt. Invoice fetching applications can turn pixels into data using sophisticated OCR (optical character recognition). The data is then turned into a business transaction that can be imported into an accounting system.
The books of many government agencies, nonprofits, and large businesses need to be audited on a regular basis. Auditing is an expensive process. Smart programs can review a company’s data and assess where the risks and anomalies are so that the audit program can be modified to focus on the more important parts. This reduces risk and cost for everyone involved.
Artificial intelligence can help to speed up the matching of purchase orders, packing slips, and invoices so that accounts payable tasks are streamlined. It can also automate approvals and look for duplicate invoices to avoid overpayments.
Accounting Tasks That Are Clerical
Robotic Process Automation (RPA) is a platform that allows users to create automation without involving the IT department. Think Excel macros or Zapier on steroids. Any workflow with a mind-numbing set of clerical steps is a candidate for RPA.
AI allows accountants to spend less time on routine tasks and more time on higher-level analysis work. As AI becomes more affordable for small businesses, everyone will benefit from this long-term trend.
When you purchase a new vehicle, you get the fun of riding around in a new car with the new car smell! Our job has just begun – to get your new asset recorded properly on your books. We thought it’d be fun to give you a behind-the-scenes sneak peek at our part.
The first thing we’ll ask you for is the sales contract. It will give us the payment price of your car, and we’ll use that number to record your new asset on your balance sheet. If you paid cash with no trade-in, the journal entry we’ll make is:
Debit: 2019 Toyota RAV4
Then we’ll decide on a depreciation method and book depreciation monthly or at year-end.
Debit: Depreciation Expense
Credit: Accumulated Depreciation
If you traded in a vehicle that is on your books, we’ll need to make an adjustment to your books. Effectively, your old car will be eliminated from your balance sheet. If this asset had a book value and it was not fully depreciated, the net value would be compared to the trade-in value and a gain or loss on the asset sale would be recorded on your income statement.
Let’s say the balance sheet value of the three-year-old car you traded in was $10,000 and you got $8,000 on the trade-in. Here’s what we would record:
Debit: 2019 Toyota RAV4
Debit: Accumulated Depreciation
Debit: Loss on Sale of 2016 Car
Credit: Old 2016 Toyota RAV4
$17,500 ($25,500 – $8,000 trade-in)
We’d also start the depreciation for the new car.
New Car Loan
Most often, a new car purchase will be financed, so we have a new liability to record too. We’ll need to get a copy of the loan documents from you and an amortization schedule of the payments. Let’s say you made a ten percent down payment with no trade-in. Here’s how that would look:
Debit: 2019 Toyota RAV4
Credit: Toyota Loan
Then, each time you make a monthly payment, the amount will need to be split between principal and interest and those amounts will need to change each month.
Debit: Interest Expense
Debit: Toyota Loan
We left out a few trade secrets just to keep it intriguing. There are a lot of other numbers on a car purchase: taxes, licenses, warranties, add-ons, fees, and more. Some of these can be directly expensed, while others need to be included in the value of the asset. So if you’re happy that we’ll take care of this for you, we’re happy to do so.
Let us know if you purchase an asset this summer so we can get it booked right for you.
Hiring a new employee is a big accomplishment in any small business, and there are a lot of steps involved, too. Here’s a handy checklist to help you stay organized when you bring that new hire on board.
First things first, the legal and accounting items:
- Signed employment agreement, typically an offer letter. There may also be a supplemental agreement outlining employee policies.
- Payroll documents include:
- IRS form W-4
- Form I-9
- Copy of employee’s government-issued ID
- Most states require a new hire report to be filed; sometimes your payroll system vendor will automatically file this for you.
- Notify your workers comp insurance carrier.
Next, it’s time for employee benefits enrollment:
- Health insurance
- Any other benefits you provide
- Provide the employee with the holiday schedule
- Explain their PTO and vacation if not already explained in the offer letter
Set your new employee up for success with the right equipment:
- Desk, chair, lamp, other furniture
- Coffee mug, refrigerator shelf
- Truck, keys
- Computer, monitor, mouse, keyboard, power strip, floor mat
- Office keys, card entry, gate remote, parking assignment
- Filing cabinet, keys
- Office supplies
- Cooler, other supplies
Your new employee may need access to your computer software systems:
- Employee email address
- Any new user IDs and password for all the systems they will need to access
- Document access
How will your new employee learn the ropes?
- Set up training
- Assign a buddy
Hopefully, this list will give you a start toward making your employee onboarding process a little smoother.