Why use clearing accounts in your accounting system for Paypal, Credit Cards, Amex, etc.?

In our highly connected, networked, real time information world, you'd think when you make a payment on a credit card, the amount is immediately transferred to the merchant (the business you're buying from).It is one of the banking systems little secrets that this isn't the case, and it's going to take a major change in the technology that underpins our financial system to change that. Banks & other financial institutions will tell you they're cutting edge from a technology standpoint - the real truth is they're not, with a few exceptions.

The underlying problem is that it takes 2-3 days for funds to clear through the various banking systems around the world. The more parties there are in between, the longer it takes. Technologies like block chain & smart contracts will eventually fix this, a discussion for another day.

For now, if you're an e-commerce merchant and you use a payment gateway to collect money from customers (whether that be a credit card, Amex or other payment forms), there is a delay in the funds coming into your bank account, normally 1-3 days.

So your workflows may look like without a clearing account:

  1. a customer checks out of your shopping cart
  2. you raise an "invoice" or "sales receipt" that increases your revenue and your accounts receivable in your accounting system
  3. you then pay the invoice in your accounting system against your bank account =:> this is where the problems start unless you're using Paypal

(For Paypal, this is how you do it:

  1. a customer checks out of your shopping cart
  2. you raise an "invoice" or "sales receipt" that increases your revenue and your accounts receivable in your accounting system
  3. you then pay the invoice in your accounting system against the paypal bank account you've set up. This should auto match against the bank feeds coming through from your paypal account. Work with your bookkeeper so that your workflows facilitate this. )

What will happen is your receipts from customers in your accounting system won't match the bank feeds. If you collect money on November 30th, it may not be in your bank account until December 2nd. You've crossed month end as well which compounds the problem - accountants and bookkeepers get most upset by an accounting system where the cash value on your balance sheet doesn't equal the bank statement. The bank feed technology in most cloud accounting systems was meant to address this, however the credit card clearing issue is still a gap.

Hence there's a step in between, which involves the use of the clearing accounts

  • a customer checks out of your shopping cart
  • you raise an "invoice" or "sales receipt" that increases your revenue and your accounts receivable in your accounting system
  • you then pay the invoice in your accounting system against your credit card clearing account
  • you then mark receipts that come in from your bank feed against that clearing account. Money in, money out.

The balance of the clearing account at the end of the month would be made up of two amounts (run a balance sheet and you should be able to see it):

  • amounts shown as "paid" in your shopping cart which haven't been received yet into your bank account. As a check, this is normally 2-3 days trading
  • most merchants now charge the merchant fee separately, rather than offsetting it against your receipts. If you have differences it could be your merchant facility is doing an offset still.
  • chargebacks from customers. These can be very hidden, the amounts can creep up on you if you're not on top of it. The clearing account reconciliation at least makes sure you're aware of them.

Is any of this ideal? I'm afraid not, there is substantial manual work in reconciling the amounts you get as receipts on your bank statement vs your sales from your shopping cart, with the different date just compounding the problem of matching these off.

Use a clearing account. At the end of the month, take a look at the balance. If it's substantially different to 2-3 days sales, it's worth digging into to see if you have leakage in your business due to the funky way the global banking systems work!

About the Author

Connect with Rachel on LinkedIn
More information about CFO for Rent


Online Retailer Saves 10 Hours Per Week

Sign up for a free 7-day trial with OneSaas and save 10 hours this week!

Formerly a contemporary art curator, writer, and researcher, Milena is now a successful handmaker
who started off making natural skin care products for her friends in 2007. Having received
large amounts of positive feedback, Milena launched Just the Goods in 2009 so more people
could enjoy her made-to-order products. Just the Goods is a way for people to experience
natural skin care without any exposure to mass produced chemicals. Based in Winnipeg, Canada, she receives orders from around the world. Milena’s products have been granted Champion Status by the Campaign for Safe Cosmetics and is revolutionizing skin care for all.

When business apps get along

Just the Goods uses Shopify for its online store and QuickBooks Online to manage its
accounting. OneSaas seamlessly connects these two apps so that Just the Goods saves
time and money.

When Milena creates new products in her Shopify store, her products are automatically created in QuickBooks, and when she updates her stock level in QuickBooks, the stock level is automatically updated in Shopify. When customer orders are placed in Shopify, the invoices are also automatically created in QuickBooks. When a customer cancels an order or requests a refund, the refund receipt is automatically created in QuickBooks.

Reliability and Confidence

Before OneSaas, Milena was manually entering data with many instances of typographical
errors: “the process was tedious.” However, she discovered OneSaas and is extremely satisfied with her experience. She believes that she should have made OneSaas her first
choice from the very beginning and has enjoyed the utility OneSaas has provided her.

Milena also loves how reliable OneSaas is with data transfers; she trusts the solution and is confident that her data will not be misplaced. “Every data sync is reliable, and the information transferred is exactly what I want and need without extras I'm forced to change manually so my invoices remain consistent.”

More Time Leads to More Opportunity

Just the Goods is a small-scale operation that is run by one person by choice. Milena stated, “OneSaas has helped save time on administration so I can redirect attention toward both customer service and production.” By having OneSaas constantly by her side, Milena is able to focus more on what she likes best and is simultaneously saving time and money.

“It is much easier to start work each day knowing orders from the previous day have already
appeared in QBO, and all I need to sort out my production schedule is to look at what clients have requested. Easy!”

Get started with OneSaas today!

Sign up for a free 7-day trial with OneSaas and have a similar experience!


Online Fashion Retailer Gets Bookkeeping Done While She Sleeps

Sign up for a free 7-day trial with OneSaas and get your bookkeeping done while you sleep tonight!

Amazon Fashions is based in Ballina, NSW, Australia. For over 18 years it operated as a physical store on the main street of town. Karen and her husband purchased the business in 2007 and now operate it as an online store only - although Karen does make the occasional house call in the Ballina area. With three main collections (fashion clothing, formal dresses, and work clothes), Karen is providing an affordable and easy way to shop for clothes. Her customers keep coming back because her number one priority is customer satisfaction.

When business apps get along

Amazon Fashions uses Shopify for its online store and Xero to manage its accounting. OneSaas seamlessly connects these two apps so that Amazon Fashions saves time and money.

When Karen creates new products in her Shopify store, her products are automatically created in Xero, and when she updates her stock level in Xero, the stock level is automatically updated in Shopify. When customer orders are placed in Shopify, the invoices are also automatically created in Xero. When a customer cancels an order or requests a refund, the refund receipt is automatically created in Xero. She has even now linked her eBay online store through OneSaas and she believes it will save her lots of time.

Work gets done while you sleep

Before using OneSaas, Karen was spending lots of time manually entering data from Shopify to Xero, which led to human errors. Here is how she described her frustration: “I was wasting so much time with the whole process it was driving me mad.” She knew that there had to be a solution for her problems.

Karen was excited when she came across her solution: “OneSaas has changed my life and saved so much time by linking Shopify with Xero.” It has allowed Karen to spend much less time on her bookwork and more of her time developing and growing her business: “OneSaas integrates Xero with Shopify beautifully and everything happens while I sleep.”

Time savings leads to business growth

Now Karen manages her daily transactions using the integrations OneSaas offers and finds her experience with OneSaas to be life-saving: “I feel like my business can grow as big as it wants and I’ll cope.” Karen finds the OneSaas customer care great to work with: “Any problems I've had, they've helped out really quickly and explained what happened. Love OneSaas and totally recommend it to you.”

Get started with OneSaas today!

Sign up for a free 7-day trial with OneSaas and start saving time yourself!


How This Mompreneur Found Extra 5 Hours Per Week

Sign up for a free 7-day trial with OneSaas and find 5 extra hours this week!

Melissa is a mother of two. She started making baby clothes for her daughter with a borrowed sewing machine and travelled to the U.S. for fabric. In 2013, she decided to create a business to bring fun and innovative fabrics into Canada. That is how Funky Monkey Fabrics Inc. was born. With over 2500 designs, Melissa revolutionized the Canadian fabric industry and was a top-5 finalist for Canada’s Mompreneur Start-Up award.

When business apps get along

Funky Monkey Fabrics Inc. uses BigCommerce for its online store and QuickBooks Online to manage its accounting. OneSaas seamlessly connects these two apps so that Funky Monkey Fabrics Inc. saves time and money.

When Melissa creates new products in her BigCommerce store, her products are automatically created in QuickBooks, and when she updates her stock level in QuickBooks, the stock level is automatically updated in BigCommerce. When customer orders are placed in BigCommerce, the invoices are also automatically created in QuickBooks. When a customer cancels an order or requests a refund, the refund receipt is automatically created in QuickBooks.

Simplicity at its Finest

Melissa used to spend hours manually inputting data from her online store to her accounting platform. She did not like the tedious work: “Before OneSaas I was manually entering all my sales one at a time. It was a process that I dreaded and usually got so far behind at, that I would spend hours upon hours playing catch up at the end of each month.”

With OneSaas, her life was made easier by saving her up to 5 hours a week: “It is so smooth. I don't even think about it now, I just let OneSaas do its job while I focus on the fun parts of my business!”

Confidence and Trust are Key

With OneSaas, there is nothing to really worry about. As Melissa stated, “OneSaas transfers all of my customers’ data and website orders to Quickbooks every day for me. I receive an email with an update on how many transactions were imported and if there were any issues that I need to address.” She is happy that she can go about her day confidently knowing that OneSaas will correctly transfer over any data she pleases.

“OneSaas is a wonderful tool for anyone with a website and a QuickBooks account. I process 40-50 orders per day and not having to input each of those is a life saver!”

Get started with OneSaas today!

Sign up for a free 7-day trial with OneSaas and start saving time yourself!


4 important things for online retailers to consider when collecting sales tax

If you are an e-commerce merchant in the USA, then it’s likely you need to deal with US sales taxes. This is a highly complex area due to the number of jurisdictions involved, all of which have different rules.

45 of the 50 states charge sales tax, up until recently this was on products only. Some states have started adding in services as the size of the service sector grows, again this differs by state.

(This is different from something other countries have called a Value Added Tax (VAT) or Goods & Services Tax (GST) which is charged on both products & services, is normally a flat rate, it’s not variable by product, and it’s charged regardless of whether you’re selling to a wholesaler or to an end user.)

As a business owner, collecting tax on behalf of the government (any government) is a fact of business life. As an e-commerce merchant, you want to automate as much as possible within your sales systems. However, given the complexity of the rules, how do you make sure you’re not paying too much?

To start with, these four questions are the main ones you need to be able to answer, in this order.

    • A. What state are you in

 

    • B. What states do you sell to other than your home state

 

    • C. Do you sell a product or a service (or a mixture of both)

 

    • D. Are you selling to a wholesaler or end user

 

We’ll use an example here, where you’re a seller of designer flip flops in California, in an area with a sales tax rate of 7.5%.

A. What state are you in? 

In California, the sales tax rate is 7.5% (including 1.25% for mandatory local taxes). If you’re in Union City (part of Alameda County) this goes up to 10% with the local tax rate.

By way of comparison, Oregon is one of the 5 states, for example, with no sales tax. Alaska has no state sales tax however allows local counties to levy sales tax.

So any products sold and shipped from a business based in California will attract a 7.5% rate.

B. What states do you sell to other than your home state

To protect small businesses from the complexity of multi-state taxation, the federal government provides limitations on how states can tax the sale of goods across state lines. The Supreme Court has established that states cannot require out-of-state sellers to collect taxes from their customers unless they have a nexus within that state.

Literally translated as a “connection,” a nexus means that your business meets one or more of the following criteria:

  • Your business has a physical location in that state
  • Some of your employees reside and work in that state
  • Your business has property (this includes intangible property, like trademarks, copyrights and patents) in that state
  • Your employees regularly seek or perform business in that state (for example, if you have an active salesperson in that state)

This means that most online sellers can ship goods out of state without having to charge or collect sales tax. Keep in mind, however, that if you have some sort of physical presence in a state, you may be responsible for collecting sales tax from customers from there.

In our example, you have an office in California but not anywhere else. However, let’s say Macy’s decided they wanted to stock your product and you need to hire an account manager in Ohio to manage that relationship.

On this question, the answer is probably yes you do need to include sales tax for Ohio. However, this would be overridden by the 4th question, in that Macy’s would be a wholesaler in this case.

A better example would be if you decided to open a physical store in New York. At that point you’d need to consider sales tax for New York State (& local).

C. Do you sell a product or service (or mixture of both)

For our example, you sell designer flip-flops. That’s pretty clearly a product.

However, there are many examples where the lines are blurred. For an equipment installation, if the customer is buying the equipment and the installation is part of the purchase, the service in some cases is subject to sales tax. However, if you need to get your air conditioner repaired, and that means replacing a couple of small components, then the product is incidental to the service being purchased and hence it’s the service that’s assessed.

This is a good one to get advice on. These categories are never clear cut, a good accountant who knows your industry will be able to give you industry guidance here which is always your best bet.

D. Are you selling to a wholesaler or end user

Let’s say you get a contract where your flip-flops will become part of a set “outfit” (they’ve been noticed by a celebrity in Hollywood). If the company you’ve contracted with will then onsell your product as part of a total outfit, then in that case you wouldn’t charge sales tax, as they will do so in full once they sell the full outfit to the end purchaser.

As you can see, this is a highly complex issue. What’s the best thing to do?

  • Make sure you know the answer to these 4 questions and get advice from your accountant if you need to pay sales tax, and how much.
  • Setup your inventory items in your shopping cart system with enough detail so the automatic calculations can work effectively, based on both the product code, the bill-to address of your customer & your customer type (wholesale vs end user). If your accountant can’t help you with the right systems choices, it might be time to find a new accountant…….
  • Your shopping cart may round up on every order, which will protect you on audits however may mean you’re paying too much, especially if you have a large number of smaller sales. OneSaas will take your sales from your shopping cart and fix this in your accounting system so you’re not paying too much due to “rounding up”.

About the Author


Connect with Rachel on LinkedIn
More information about CFO for Rent