A few good bookkeeping links

bookkeeping links.png

When I'm not bookkeeping or writing, I'm often reading. When I was younger it was Stephen King books. Why a 5th grader submitting books reports on Carrie or The Dead Zone didn't raise any red flags is beyond me. Nowadays it's not nearly as many books as it used to be; and almost nothing fiction. Instead, I read a lot of blog posts. My RSS reader (yes, I do still use RSS) is filled with a wide range of topics. From bookkeeping to tech news to music blogs, I'm constantly adding and subtracting blogs that interest and inform me.

During this reading, I come across a lot of great posts and great resources. It seems silly to not share those with you. It's not as though I think I've got the market cornered on bookkeeping tips. If you like reading about bookkeeping, maybe there will be some new sources here.

As a self-serving bonus, I also added a link to an old post on this site. I just rewrote it and I think it's got some great advice.

BlakeOliver.com: I follow Blake on Twitter and he's constantly sharing great content. He also has a blog of his own. He did a great post recently about accounting podcasts to check out, which I really enjoyed.

Adventures of a QBO Bookkeeper: If you are using QuickBooks Online, or plan to soon, Jennifer provides tons of great advice.

The Sleeter Report: If you have ever gone online and read about bookkeeping and accounting, chances are good you've come across The Sleeter Group. They have their own convention each year (SleeterCon), but they also have a ton of great posts on their blog. They cover lots of aspects about cloud accounting...which I find particularly useful.

School of Bookkeeping: This isn't a blog (although there is one linked to the site), but a complete training centre for all things bookkeeping. If you are a bookkeeper, and you want to get some video training, Seth has tons of great information. It's a paid membership, but I think well worth it.

6 Ways to Maintain a Positive Cash Flow: I wrote this way back in 2010 but it's just as true today as it was then. I hope you find it helpful.

If you have helpful sites you'd like to share (bookkeeping-related or otherwise), please let me know by adding a comment or replying to this email.

Eric Matthews

I'm a bookkeeper, husband, dad, music junkie, and general tech geek. When I'm a bookkeeper, I focus on cloud bookkeeping. I write at ThatBookkeeper.com, which helps bookkeepers and business owners move their books online. I work with apps like FreshBooks, Xero, Kashoo, Wave, and QuickBooks Online.

Subscribe to my free newsletter!

3 Things I Don't Know About Cloud Bookkeeping

learn about cloud bookkeeping.jpg

I'm not an idiot, but I play one on TV...as long as by TV we mean business.

Generally speaking, I've got bookkeeping software figured out. No, I'm not an expert at everything out there, but you can throw me in front of any bookkeeping app and I'll figure out how to get my job done.

There are a few types of software out there, both for business owners in general and specific to bookkeepers, that I haven't been able to wrap my head around. I'm not sure how they would fit into my business, whether or not they're worth the expense, and which one of them is the best fit.

I'd like to talk about 3 of them today. I hope this inspires some good conversation. Maybe some of you will be comforted in the knowledge that you aren't alone in this confusion, while others will be able to shed some light on what I'm getting wrong.

CRM (Customer Relationship Management) Software

What I know: CRM software helps you manage the people you interact with through your business. That can range from potential prospects to long term clients. It helps you manage sales, marketing, customer service, and technical support.

I know that sales people use this quite a lot to manage "leads". I know it's also helpful to keep track of your client's relationships. When was the last time you spoke? What issues have they had with your products in the past? That kind of thing.

What I don't know: Is it worth spending the time to set up the software and maintain the system if you're a one-person shop? How much time and money will it save me? That answer might help ask; how much money should I spend on CRM software? It seems to range from free to $50/month for the small biz tier...and I'm sure there are pricier options too. I've tested out a few. I spent a couple days getting them setup, and then never remembered to go back and maintain the system. It's very possible that's a sign that it's not for me, but maybe I just didn't know how to approach it properly.

Document Management Software

What I Know: I know plenty about Dropbox, and how important document management is for a bookkeeping practice. There are quite a few services out there tailored to bookkeepers and accountants that help manage your client's documents in a secure way.

What I Don't Know: Dropbox has been my goto because it's what most of my clients are already using. I've always had the approach of bringing my services to them. One complaint I hear from owners is frustratration when they're forced to start working with their accountant's software. But there are benefits to document management that's built for this purpose. It might be more robust and more secure. I just don't have a clue which of the dozens of options out there to try out.

Client Management Software

What I Know: Think of Client Management (or sometimes Practice Management) software as CRM software plus time tracking and billing plus document management plus more. It's a lot of software and can be quite pricey. It handles your entire bookkeeping or accounting practice. The only thing it doesn't include is the actual bookkeeping software.

What I Don't Know: Similar to CRM software, I'm not sure if this is overkill for a solo operation. I'm also not sure about having one app handle all of these tasks. On one hand I like having everything in one place. On the other hand, I would wonder if I could piece together a stronger set of features for the same or less money.

Your Turn

So, here's 3 things I don't know much about...pulled from a much longer list. What about you? Running a business is hard, and you're not expected to be an expert at everything (or anything really) right away. What things are you struggling with right now?

Is it choosing the right bookkeeping software? Maybe it's how to find clients. Whatever it is, let me know in the comments or by replying to this email. I might not have all the answers but I love any chance I can get to talk to people about small business.

Eric Matthews

I'm a bookkeeper, husband, dad, music junkie, and general tech geek. When I'm a bookkeeper, I focus on cloud bookkeeping. I write at ThatBookkeeper.com, which helps bookkeepers and business owners move their books online. I work with apps like FreshBooks, Xero, Kashoo, Wave, and QuickBooks Online.

Subscribe to my free newsletter!

How Are You Going To Get Paid?

Getting paid used to be pretty simple. You'd send your client an invoice, and they'd eventually send you back a cheque (sorry...check). Once in a while they'd forget, so you wouldn't get paid for months. Other times the cheque would bounce. Look, I didn't say it was better...just simple.

So you want to start an online business? How are you going to get paid? Let's go through some of the options available to you.

The Worst: Cash or cheque

Not that long ago these were the only two options available. Now they're usually the least desirable.

Pros: No merchant fees for either, and cash is immediately available.
Cons: No paper trail with cash. Cheques can bounce and most banks will hold the funds for a few days until the cheque clears.
Summary: Cheques are a pain in the butt. If it's a remote client you have to wait for snail mail. Then you have to wait while the bank places a hold on the funds. At least where I'm at it's usually a 2 week delay from "the cheque's in the mail" until I can use the funds. Cash is great. Who doesn't love cash? But unless you're breaking bad, no self-respecting business owner uses cash as their primary payment method. You look super-sketchy when you only accept cash. Plus, imagine if a delinquent client claims to have paid you in cash. Good luck proving them wrong.

Middle of the Road: Merchant accounts

This can range from a PayPal account to a merchant account issued by your bank.

Once you start taking payments from people online, it really helps to have a method that doesn't require a face-to-face transaction or the post office.
Pros: Easy for clients (remote and local) to pay you. Wide range of types of accounts to choose from. Faster than snail mail.
Cons: Merchant fees. Most transactions will incur a fee. There's a big range, depending on the type of account, but the standard rate will usually fall between 2-3%.
Summary: People getting started with an online business often begin by setting up a PayPal account. It's easy to setup, doesn't require good credit, and lets your clients pay you by credit card, their PayPal balance, or even an electronic cheque. However, fees are usually 2.75% plus $0.30 per transaction. You can then spend the money directly from the PayPal account, withdraw the money to your bank account, or in some countries (not mine) you can use a PayPal debit card. I've personally never had any problems with PayPal (other than hating the fees), but I've heard a lot of horror stories about frozen funds. If you want an alternative, there are plenty of other options. Stripe and Square are two of the big names. They both have similar rates so you're not saving any money at this point. I know Square offers a free device that connects to your phone that lets you swipe cards. This is great for taking payments in person. The (potentially) big jump comes when you get a merchant account at your bank. In Canada you'll be dealing with companies like Moneris or Chase Paymentech. I'm not sure the big names elsewhere. Getting these accounts requires more paperwork and a credit check.
There are benefits to getting the extra scrutiny. If you are taking a lot of in-person payments each month you could be getting much better rates. When I ran a small retail shop we were getting 1.75% on all credit cards. If you're doing $10,000/month on credit cards that's an extra $1,200 in your pocket each year. I'm not sure the rates you'd get for over the phone or online payments but they're usually going to be less than PayPal's. Unfortunately companies like Moneris are very private about their rates until you're actually signed up. You can also accept debit cards, which is the main form of in-person payment in Canada. Finally, the turn around time for deposits is much quicker. If the merchant account is tied to your business bank account you will often received the funds the next day. In my experience, cash flow will make or break your new business. Having the money a day or two sooner makes a big difference. If you don't believe me, ask your employees if they mind getting paid on Monday next time.

The best: Direct deposit

This includes ACH, wires, email money transfers, etc.

Pros: No fees (usually...see the summary). Faster than snail mail, and often faster than merchant accounts too.
Cons: You have to exchange sensitive info with your client. They have more work on their end getting you paid.
Summary: Direct payments represent the best of both worlds. You're getting paid quickly but usually not paying any fees. Domestic wires and email transfers can actually show up the same day; ACH payments only take about 2 business days. International wires are quite fast too. I have US clients, and wires usually show up in 1-2 business days. The real trouble is actually on your client's side, which might deter them from wanting to pay you this way. I mean, it's not a lot of work, but enough that if they aren't already paying their contractors this way, they might resist. It's also pricey for them if you need a wire. Domestic wires are about $30, and international ones are about $40. In some cases they split the cost with the contractor. So, if you are an international contractor, and your client asks you to cover $20 of the wire fees, it's worth comparing the rates. Small invoices are better off being paid by PayPal, but once your invoice hits 4-digits it's cheaper to chip in for the wire.

Yes, I know there are other options.

There's also bitcoin. I know almost nothing about it so I'm in no position to give you any info on the subject. Thankfully, the folks at The Sleeter Group did a "Bitcoin for Small Business" video series about it.

I suppose you could also get paid with a money order or Western Union. Heck, you could barter or take gift cards too if you want. These are all possibilities, and the point is that you receive something of value for your services. If you are happy to reconcile a few bank statements in exchange for a tire rotation and a couple loaves of banana bread who am I to judge?

It's just important to be aware of your options, and make a plan before you get started.

7 Tips to Prevent Sync Issues in FreshBooks

The term synchronize seems too technical to inspire a lot of emotions. But tell someone that they just lost their data due to a "synchronization error" and all sorts of emotions begin to emerge.

Sync (or is it synch?) has been one of those features that you love and hate. Everyone wants their app to sync with something else. All the software developers make sure to highlight sync on their features page. Yet it's also the one feature that seems to be the most prone to catastrophic problems. Who reading this hasn't had a phone suddenly end up with 3 copies of everyone's contact because of a sync issue?

Yet despite all of the problems we have with sync, I have to rely on sync daily to keep something as important as my client's bookkeeping data up to date.

FreshBooks is a great app for time tracking and invoicing, but it doesn't handle all bookkeeping tasks. That means I need to get that data into another app. The way bookkeeping data is synched with FreshBooks is entirely one-time, one-way.

I create an invoice in FreshBooks. As soon as it is sent, it gets synced into the receiving app, like Xero or Kashoo. That's where the synching stops. If I make changes to that invoice in Xero, those changes don't go back to FreshBooks. Conversely, if I make changes to the invoice in FreshBooks the changes don't get sent to Xero. Payments will sync across later on, but that's it.

Why is this important?

There's usually a reason we're using 2 apps. In my case, it's usually a situation where the client is using FreshBooks day to day, and I'm using Xero or Kashoo. If either of us makes changes to an invoice, the other side doesn't see the updates in the reports. This means there will be discrepancies between both sets of books. If it was always the case that Xero was right and FreshBooks was wrong then I could just send the client some reports each month. But that's not the case. More often than not it's my data that's wrong.

So, bookkeepers, what are we to do? Here are 4 steps to make sure your data stays in sync.

  1. Be aware of the fact that this is an issue. Just being aware that this is an issue will help you prepare.
  2. Make sure your client is aware. Let them know that changes they make to FreshBooks invoices after they're sent don't update the data in Xero or Kashoo. This might make them less likely to make late changes, or at least let you know when they do.
  3. Make a checklist of areas you'll want to review each month before generating final reports.
  4. Create revenue and receivables reports in each app. Once the numbers in both apps match then you're good to go.

Just because 2 checklists are better than 1, let me run you through the 3 most common situations that would cause the data to get out of sync.

  1. Invoice totals are adjusted after they are sent. This usually happens on the client side. Maybe someone submits their time late and has to add it to the invoice later. Sometimes the customer pushes back about certain line items and adjustments need to be made.
  2. Invoices are written off or deleted. I don't mean bad debt writeoffs down the road. This just means that, after it was sent to the customer, the invoice was fully discounted or removed.
  3. Payments are changed or removed. All payments will sync across properly, but sometimes a payment is reversed, removed, or applied to a different invoice.

Until we get better sync this is just going to be something we have to deal with. If you put together a detailed plan, and follow it each month you should be fine.

Let me know if you've had this problem before: either in the comments or by replying to this email.

What, you don't get these posts delivered straight to your inbox? You can sign up for my free newsletter here.