Transform Your Business With Spreadsheet Accounting – Part 1

When a new client approaches me to do their accounting for them, they often bring in their previous financial “system”… which usually consists of cardboard box overflowing with files, receipts, envelopes, and notebooks of spreadsheets. The first thing I do, before I start any official “help-them-save-money-and-make-more-money” accounting work, is to roll up my sleeves and systematize the avalanche of papers.

If your small and growing business doesn’t have an accountant yet, or if you want to make it really fast for your accountant to get through your records and start delivering the meaningful insight that you are hiring them to provide, you need to build and implement a spreadsheet-based accounting system as early as possible.

Read More »

Tags: Accountant, Accountants, Accounting System, Avalanche, Business Profitability, Cardboard Box, Cash Flow Statement, Envelopes, Google, Google Spreadsheets, Gross Profit, Income Statement And Balance Sheet, Meaningful Insight, Microsoft Excel, Profit And Loss, Profit And Loss Statement, Receipts, Spreadsheet, Step 2, Step 3

Handling Credit Card Processing Fees (or PayPal Fees) in QuickBooks

There is always that never ending problem, where you just don’t get all of your income

Many merchant accounts (these are the people that permit you to accept credit cards) just take a monthly debit out of your bank account at the end of the month, these are easy to account for, you simply enter a withdrawal in your account register for the amount debited and categorize it as Merchant Processing Fees, which should be a COGS or an Expense (this varies by where you are located and your industry, check with your accountant if you are unsure).

However, what about those merchant accounts that take the percentage before you even get the money, similar to Paypal? This makes it more difficult to track, however, I do have an answer.

Read More »

Tags: Accountant, Accounting, Cash Receipts, Chase Paymentech, Checking Account, Checkout, Cogs, Credit Card Processing, Credit Cards, Google, Invoices, Lump Sum Fees, Matter Of Fact, Merchant Account, Merchant Accounts, Monies, Paypal Account, QuickBooks, Three Ways, Worry