616-610-3750
info@denuylaccounting.com
Menu

Marti DenUyl

About Marti DenUyl

Posts by Marti DenUyl:

How to Set Up a Bookkeeping Cycle in QuickBooks Online

, , , , , , ,

Do you have a regular schedule you follow with your QuickBooks Online work?

Whether you’re a new QuickBooks Online user or a long-time user, having a regular accounting routine can make you more productive and confident that you’re addressing all of your accounting issues.

What Should You Do Every Day?

Even if you don’t have expenses to enter or invoices to process, it’s a good idea to log into
QuickBooks Online every day. If you’ve connected your online bank and credit cards to the
site (which you absolutely should), there will probably be transactions to go over. So after
you’ve taken a look at your Dashboard (especially your Tasks), hover your mouse over
Transactions in the toolbar and click Bank Transactions.

Click Update in the upper right to make sure you’re seeing the most recent transactions. If
you’re doing this every day, it shouldn’t take long to go over the income and expenses that
have been imported since you last logged in.

You should be looking at newly imported transactions daily and completing the fields
provided as comprehensively as possible.

If you don’t know what Match or Record as transfer mean, we should schedule a session
to go over how those work to avoid duplicate transactions in QuickBooks Online.

Every Week

You need to be monitoring your accounts receivable and payables on a weekly basis – at
minimum. There are two ways to do this. You can:

Run reports

  • Click Reports in the toolbar and scroll down first to Who owes you. Run Accounts receivable aging summary. QuickBooks will display past-due transactions in several columns (Current, 1-30 days, 31-60 days, 61-90 days, and 91 and over). If you’re keeping up with your receivables, you shouldn’t be seeing numbers in most of the columns, unless you’re in a known collections process.
  • Scroll down to What you owe and run Accounts payable aging summary. This works like the aging receivables report. Again, you shouldn’t be seeing much activity here unless you’re in a payment dispute with a vendor.
  • You can also run the Open Invoices report to quickly see the Due date and Open balance entries here. Ditto the Unpaid Bills report.

Consult the All Sales page

Hover your mouse over Sales in the toolbar and click All Sales. The colored bars and
numbers at the top of the page show you the status of your sales. Click the orange bar in
the middle to see a list of overdue invoices. If there are any, you can set a Send
Reminder by clicking the corresponding down arrow in the Action column. While you’re
there, look at estimates and unbilled income and take any action needed.

Every Two Weeks (or more often, depending on product volume) If you sell products and track inventory in QuickBooks Online, you should keep a close eye on your stock to see if you need to:

  • Reorder,
  • Bring in a larger supply because something is selling well, or,
  • Discount or discontinue a product because it’s not selling.

Click Reports in the toolbar and run Product/Service List under Sales and Customers
and look at the Quantity on Hand column.

Every Month

Reconcile your accounts (Transactions | Reconcile)

It’s really important that you reconcile your accounts every month.

No one likes to do this, but it’s way easier to do regular reconciliations than it is to have to
go back several months to track down a problem. If you’ve never done this in QuickBooks
Online, it works similarly to how you used to reconcile your accounts by comparing a bank
statement and your paper checkbook register. Only you’re comparing your bank or credit
card statements to your accounts in QuickBooks Online. Before you start, make sure
you’ve matched and categorized all of your downloaded transactions.

Run a Profit and Loss report for the last month

Click Reports in the toolbar and click Profit and Loss under Business Overview. Did
you make a profit last month?

Every Quarter

If you’re planning to apply for a loan or looking for an investor, or if you just want a deeper
understanding of how your business is doing, consider having us create and analyze
standard financial reports for you, like the Balance Sheet and Statement of Cash Flows.

Lastly, If you ever have trouble categorizing an expense, select Ask My Accountant as the
Category. If we’re meeting with you once a month, we can run a report on these and help
you categorize them correctly.

Give the above a try, review your results, and adjust the schedule as necessary to ensure all your accounting tasks are completed.

How to Link Your Bank and Credit Card Activity into QuickBooks Online

, , , ,

If you’re still manually entering your banking and credit card activity into QuickBooks Online, we suggest you consider setting up connections to your online bank and credit card accounts. Once your transactions are delivered to QuickBooks Online, the site provides tools that allow you to view them and make sure they’re complete before you record them.

Here are step-by-step instructions to how this all works.

Making a Connection

In order to do this, you’ll need to have set up a username and password for your online bank/credit card accounts. In QuickBooks Online, click Transactions | Bank transactions. Click Link account over to the right.

A page opens with suggested financial institutions. If yours isn’t there, enter it in the search field at the top. If there are multiple options, be sure to select the correct one and click it.

If your bank isn’t listed on the page of options, enter its name, and then click on the correct one if there’s more than one entry.

Click Continue and go through any of the security steps your financial institution may have. You’ll get to a page that says, Which accounts do you want to connect? A drop-down list displaying options from your Chart of Accounts will appear. Select the type of account you’re creating (checking, credit card, etc.) and continue to follow the onscreen instructions until your connection is complete and QuickBooks Online has downloaded your transactions.

WARNING: It’s important that you set up your linked accounts correctly since you’re dealing with the Chart of Accounts. If any step is confusing, we can schedule a session to go over online account connections with you.

Bank Transactions Page (Feed)

Once you’ve connected to all your online accounts, you’ll see that they appear on the Bank transactions page, displayed in small boxes containing their balances and the number of transactions they contain (there might be quite a few when you first download). You can also see how recently each account was updated (click Update anytime you want to refresh an account).

Once you’ve connected to an online bank account, you can see how many transactions were downloaded and what its balance is.

Click one, and its register will appear below. Above that, you’ll see three labeled bars:

  • For review. QuickBooks Online puts all downloaded transactions in this list.
  • Categorized. Your transactions will move to this list after you’ve assigned categories to them.
  • Excluded. If you happen to run into duplicate transactions, you can move them here.

Below that, you’ll see that you can filter your transactions by date, by type, or by description, check number, or amount.

WARNING: As you continue to work with accounts, you may occasionally find that a connection has been unlinked. When that happens, just repeat the connection process again.

Working with Individual Transactions

You’ll want to set some time aside the first time you download transactions so you can look at each one and add or edit its content. Click one to open the detail box, as shown below. The top line defaults to Categorize. First, select the correct Vendor/Customer (or  + Add new), then check the Category and change it from the drop-down menu if it’s incorrect.

You can add or edit a lot of details for your individual transactions.

There’s one more field here that’s very important. If you’re purchased something on behalf of a customer, be sure to select the correct one from the drop-down list under the Customer field and click the Billable box. QuickBooks Online will make this transaction information available to you the next time you invoice the customer. Other fields in the above image are optional, like Tags, Memo, and Add attachment. When your transaction is complete, click Confirm to move it to the Categorized list. The transaction is now posted in QuickBooks.

There are two other options in these individual transaction boxes besides Categorize: Find match and Record as transfer.

Categorize: Find Match

When you use “Find Match,” QuickBooks is looking for a transaction that’s already been entered in your records, such as an invoice you’ve received payment for or a bill you’ve paid.

For example:

  • Let’s say a customer paid you $500, and you already entered that payment as “Received Payment” in QuickBooks.
  • When the $500 deposit shows up in your bank feed, you use Find Match to connect that bank transaction to the existing record in QuickBooks.

Record as Transfer

The “Record as Transfer” option is used when you’ve moved money between your own bank accounts, like from your checking account to your savings account.

For example:

  • If you transferred $1,000 from your business checking to your business savings account, you wouldn’t categorize it as income or expense—it’s just moving money within your accounts.
  • In this case, you use Record as Transfer to note that the transaction isn’t new; it’s just moving money between accounts.

Why These Options Matter

  • Find Match ensures your books match what’s in the bank without creating duplicate entries.
  • Record as Transfer keeps things clean and avoids accidentally categorizing your own money movements as income or expenses.

Setting up and using the bank transaction feed can feel overwhelming at first, but with practice, you’ll become more comfortable over time. If you’re feeling unsure, don’t hesitate to reach out to us for assistance. We’re here to help you set it up and guide you through the learning process to ensure you’re on the right track.

Unlock Deeper Insights: How to Utilize Classes in QuickBooks Desktop

, , , ,

Class tracking in QuickBooks Desktop allows users to track financial information by business segments (locations, departments, programs, events, etc.). It also allows you to keep your chart of accounts simplified as you don’t need to duplicate elements of your chart of accounts to track multiple business segments.

To begin using the class tracking feature, you’ll first need to turn the feature on.

Turning on Class Tracking

Click on the Edit menu at the top of the task bar. Select Preferences from the dropdown menu. In the Preferences window, choose Accounting from the list on the left, then select the Company Preferences tab at the top. Check the box next to Use class tracking for transactions.

If you’d like QuickBooks to remind you to assign a class every time you enter a transaction, also check Prompt to assign classes. We highly recommend turning this feature on.

Create the Class List

Go to the Lists menu at the top of the task bar and select Class List. In the new window, click on the Class button (usually in the lower left corner) and select New. Give your class a name. For example, if you’re tracking type of business, you might name your classes “New Construction,” “Remodel,” or “Overhead” Click OK to save.

Tip: The Subclass of provides an option to create a grouping of classes. This gives you the ability to organize your class data in greater detail as keeping the data easier to view when you run the class report. You will also have the ability to filter classes when running reports.

Assign Classes to Transactions

When you enter a transaction (like a bill, invoice, or check), you’ll see a field labeled Class. Select the appropriate class from the dropdown menu. You can also add a new class by typing in a new one or selecting <Add New> from the dropdown menu. You can also split the transaction to multiple classes within one transaction.

Class Reports

Once you start using classes, you can run reports to see how each class is doing. Go to the Reports menu, select Company & Financial, and then choose Profit & Loss by Class. The report provides a clear breakdown of income and expenses for each class, making it easier to review and use the information to make informed decisions.

Tip: Pay attention to the Unclassified column as these are transactions that have not been assigned to a class. Double click on the total for any account that shows a balance to see if anything needs to be assigned to a class. If you have activity that doesn’t require a class, we suggest setting up a generic class such as N/A so you don’t continue to review activity you have previously double-checked.

If you are consistent in using the class tracking feature, you’ll have a clearer picture of how different areas of your business are performing and can make decisions in a timelier manner.

A Beginner’s Guide to Understanding the Balance Sheet

,

Business owners tend to focus on the Profit and Loss Statement as it shows the income and expenses flowing through their business. Also, the categories (accounts) on the Profit and Loss Statement are terms they tend to use in their day-to-day business dealings.

The Balance Sheet however, uses accounting terms that might not be used on a daily basis and therefore, can be a little intimidating. If that’s how you feel, you’re not alone as We hear regularly from business owners, that they don’t fully understand the balance sheet. This article will breakdown the terms you might find on a balance sheet.

What Is a Balance Sheet?

Think of a balance sheet like a snapshot of your finances. It shows what a business owns (assets), what it owes (liabilities), and what’s left over for the owners (equity). This snapshot helps business owners, investors, and lenders understand how the business is doing financially.

The balance sheet follows a basic formula:

Assets = Liabilities + Equity

This equation is called the accounting equation, and it always stays in balance (hence the name “balance sheet”). Let’s explore each part of the equation.

Assets: What the Business Owns

Assets are all the things a business owns that have value. These can be physical items (tangible) or things that aren’t tangible (items that aren’t physical but have value). Here are some examples:

Tangible:

  • Cash: Money in the bank or on hand.
  • Accounts Receivable: Money customers owe the business.
  • Inventory: Products the business plans to sell.
  • Equipment: Tools, machinery, or computers used in the business.
  • Property: Land or buildings owned by the business.

Intangible:

  • Intellectual property: Patents, trademarks, copyrights.
  • Goodwill: Value from customer loyalty, public reputation.
  • Brand recognition: Logos, taglines, etc.

Assets are usually divided into two categories:

  • Current Assets: Items the business can turn into cash quickly, usually within a year (like cash or inventory).
  • Non-Current Assets: Items the business plans to use longer than a year (like equipment or property).

Liabilities: What the Business Owes

Liabilities are debts or obligations—money the business owes to others. Here are some common examples:

  • Loans: Money borrowed from a bank or other lender.
  • Accounts Payable: Money owed to suppliers or vendors.
  • Taxes Payable: Taxes the business owes to a government agency.

Like assets, liabilities are divided into two categories:

  • Current Liabilities: Debts that must be paid within a year (like short-term loans or bills).
  • Non-Current Liabilities: Debts that are due over a longer period (like a mortgage).

Equity: What’s Left Over

Equity is the owner’s share of the business. It’s what’s left when you subtract liabilities from assets. In other words:

Equity = Assets – Liabilities

If a business sold everything it owns and paid off all its debts, the remaining money would be the owner’s equity. Examples include:

  • Owner’s Contributions: Money the owner(s) has invested in the business.
  • Retained Earnings: Profits the business has kept rather than paying out to the owner(s).

Why Is the Balance Sheet Important?

A balance sheet is like a report card for your business. It helps answer important questions, such as:

  • Is the business financially healthy? Comparing assets and liabilities can show whether the business has enough resources to cover its debts.
  • How much is the business worth? Equity gives an idea of the business’s value to its owners.
  • Are there any red flags? For example, too much debt compared to assets could signal trouble.

The balance sheet report provides a snapshot of what your business owns (assets), owes (liabilities), and its overall value (equity). We recommend reviewing your balance sheet regularly to monitor the financial health of your business.

Five Ways to Welcome in a New Year: 2023

A new year is a perfect time for a fresh start for you and your business. Here are five ways to welcome 2023 and make it your best year ever. 

  1. Decide on a theme for 2023

Setting a theme for the year can help you remember what you want to focus on. Some examples of themes might be:

  • Growth and improvements to your business. You can be specific, such as making your theme the year of mastering technology, the year of profitability where you focus on cutting costs or increasing sales, or the year of diversity where you focus on creating a diverse team.
  • Downsizing, cleansing or simplifying. Perhaps your business has grown so quickly that you need to sit back, de-clutter, re-design, or simply clean your office.
  • Is it time to launch a new service?
  • Giving back. If everything is humming along, it could be time to start giving back to your profession or community.

From here, you can create a plan of tasks and timelines that are aligned with the theme you’ve chosen.

  1. Go on a retreat

If you need to regroup and rejuvenate from a stressful holiday season, then a retreat can do the trick. A retreat is a time to set goals for your business and make a plan. You could discover that you are on track or that you need a course correction in your business.

A retreat can be made alone or with certain team members. Typically, the events of a retreat include a combination of planning and brainstorming sessions, education, team-building, and social activities.

If a retreat sounds like too much work, then a quick vacation might be in order, just so you can enter the new year with a relaxed mind.

  1. Learn from 2022

If 2022 was a bumpy time for your business, it might be a good idea to perform a detailed review. This will help you learn what went wrong and explore why. You can then brainstorm ideas on how to avoid the pitfalls of 2022 as you move into 2023. You can make it as informal as you want, or structured as an after-action review.

  1. Select a word for 2023

If setting a theme is too complicated, how about selecting one simple word for 2023? Here are some ideas:

  • Abundance (think big, go after large contracts and big projects)
  • Creativity
  • Powerful relationships (OK, that’s two words!)
  • Gratitude
  • Service
  • Humility
  • Forgiveness (especially good if you are in customer service or have difficult clients)
  • Fun
  • Helpful
  • Prosperity

I’m sure you can think of one that will be perfect for you. Once you do, write the word on several sticky notes and paste it everywhere you work and maybe even at home. Your postings will serve as a reminder of what your intention is throughout 2023.

  1. Make a profit plan (AKA budget)

Making a profit plan for the new year will help you hone in on the profit amounts that you want to achieve. Understanding how much volume you need to reach and what you can spend will avoid surprises at year-end. At mid-year, it’s a good idea to see if you are on track for the rest of the year. 

Whether you do one or all of the ideas above, we hope you have an awesome 2023 and that it’s your best year ever. 

Load More