Q&A: Importing Transactions From Online Merchant Account

Q: We have a software division that charges people monthly on subscription plans. It’s all done automatically. What’s the FASTEST way for me to manage this? I don’t really want to manually enter thousands of monthly charges into QuickBooks every month, but at the end of the year, my accountant will want detailed records. any suggestions?

We’re using authorize.net and cybersource. I can look into importing them. I can import them from the bank, but that seems to a big pain too, as QuickBooks asks me to do each one individually pretty much.

A: Look into what your choices are available regarding the various formats that you can download the information from authorize.net & cybersource. A lot of companies offer a way to export your transactions in a way that’s ready to import them directly into your QB file. It may take some effort on your part to set it up correctly on the front end but will be well worth it not to post transactions one at a time.

I use another payroll provider that allows me to do exactly what I’ve described to import the information with no problem.

If you have additional questions regarding setup, I really think you should seek the advice of your accountant. If they aren’t available or versed in this kind of set up, shoot me an email. (remind me of our forum discussion)… I’d be happy to help.

Good luck! ~Joyce

originally asked & answered on QuickBooks Forum


Ten Ways Outsourcing Drives Your Bottom Line

  1. Freedom: outsourcing to a service provider allows you to concentrate on income generating activities, increasing your income…
  2. Reduces overhead: if you don’t have an accounting department, you don’t need the office space, telephones, cubicles, chairs, filing cabinets, etc. You can reallocate that budget to other areas or eliminate it altogether.
  3. Real time accessibility: offering you real-time accessibility to reports, you know what your cash position is at any given time that is up to date. Up to date information allows you to easily manage your cash flow… and manage your business.
  4. Secure, off-site storage/backup: not that anything catastrophic will happen but just in case, all your financial information is safe and secure. The cost and time it would take to recreate your finances could be prohibitive, if that were ever necessary. With off-site storage & backup, you don’t have to worry about that.
  5. No more hiring headaches: it’s hard to find and supervise the work of a bookkeeper when realistically, you have no idea what they are supposed to be doing and turnover is costly.
  6. No more training headaches: if hiring is a headache, training is too. And if you’re a small business owner training those coming and going through the revolving door of the employer-employee relationship can get expensive. That disappears with outsourcing.
  7. No more continuity/consistency issues: because an outsourcing provider is there for you day in and day out, you don’t have to worry about the “new person” and their learning curve.
  8. Less stress: you can relax knowing that your finances are taking care of by competent professionals and concentrate on driving your income and growing your business.
  9. Internal privacy: eliminate talking about the company’s financial health around the water cooler. Having an independent outsourcing service firm gives you, the owner, more privacy when it comes to the companies overall finances.
  10. Fixed monthly fee: like you, Common Cents is a small business and we don’t particularly care for hourly billing either… so we do a detailed review of your files to derive a fixed monthly fee for you.

Are you ready to drive your bottom line… upward? Let’s make it happen. ~Joyce


Q&A: Merchant Account Fees as a COGS

Question: Why did QB set up Merchant Account Fees as a COGS (cost of goods sold) account? Before starting to use Quickbooks, I always had the Merchant Account Fees account set up as Expense Type. QB interview set it up as COGS. (I am an artist and do keep track of inventory). Should I change it back to Expense?

Answer:The chart of accounts & the COGS account were created based on your selections during the QB setup interview. From what you’ve said so far, it sounds like you have made some incorrect selections or need some adjustments made to your Chart of Accounts.

If you are comfortable with the day to day data entry, you may want to have someone review the chart of account and other selections you’ve made to make certain that they correspond to your business appropriately. I would do this as soon as possible, you don’t want to get too far into the process or all your hard work will be for nothing.


Why Outsource Bookkeeping/Accounting?

Why should you outsource your bookkeeping and accounting functions? You might want to consider doing so for several reasons. For starters, maybe you’re someone who just hates math and accounting with a passion. There’s no shame in that; I will be the first to stand up, hold my head high, wave my arms in the air and scream, “I HATE ACCOUNTING!” (Okay, I’m kidding. I just wanted to get the admissions started.)

When you truly hate accounting and bookkeeping, you’re unlikely to do it well. Worse than that, you might even be unlikely to do it at all. While you can get away with poor personal bookkeeping, like not balancing the checkbook, you can’t with your business. If your business is going to thrive, you need the books kept to perfection. If you can’t do this on your own, or if you simply don’t want to do this on your own, outsource bookkeeping is a great way to go.

In-House Versus Outsource Bookkeeping
Another reason you might want to outsource your bookkeeping and accounting with a virtual accounting firm is to save money. While every business needs their books kept up professionally, most can’t afford to have a full-time accountant on staff. Outsourcing solves that problem by getting the job done through an outside provider. Now, with the assistance of the Internet, you don’t need to ship in a part-time subcontractor to do your books. You can have your books completed & reviewed virtually by a competent, trained professional… saving you money that you can put back into your growing business.

Saving Time With Outsourcing
Let’s suppose you’re like me and love (or at least, like) accounting. Maybe you’re even trained at accounting and feel you can keep your books better than anyone else. There’s still the matter of your time, which is best spent working on your business and making it thrive, rather than balancing books. And as we all know, time IS money…


Q&A: Self Employment Taxes

Q: I have started a small business. How do I report (tax purposes) payments to me as the owner? Is that considered income for self-employment or is the net profit from the business used for self-employment taxes?

A: For tax purposes, if you are a sole proprietor, the net profit of the business is used to figure out your self – employment taxes. Other types of organizations have different rules, but most use the amount actually paid to you to figure self-employment tax upon. This can vary from one geographic area to another.

However, no matter what business structure you have, corporation, LLC, partnership, or sole proprietorship, you should accurately track amounts that the business pays directly to you or to others for your personal items as these are paid out. Create an equity type account, use your name & the word “draws” as the account name (example: “Joyce Washington – Draws”), record these payments in this account.

In the long run, it helps to keep better track of how your business is performing if you input the payments as they are paid. Then when it comes time to figuring out your self-employment tax, you will have everything you need to determine the tax amount in one easy location.


Pin It on Pinterest