QuickBooks Tips

Recording Infrequent Transactions in QuickBooks

10/14/2020

Day-to-day transactions like receiving payments from customers or paying vendors occur so frequently that most QuickBooks users do them automatically. However, from time to time you may encounter an infrequent transaction that will stop you in your tracks. In this article we’ll discuss several common tricky transactions and offer advice on how to handle them.

Security Deposits

Security deposits, such as for a rental space or to a utility company, require special tracking so that you can be sure to get the money back later. It’s best to maintain a separate account for each security deposit so that you can track each individually. If you have numerous security deposits, consider creating individual subaccounts for each deposit:

  1. Choose Lists, and then Chart of Accounts (or press Ctrl-A).
  2. Click the Account button, and then choose New (or press Ctrl-N).
  3. As shown in Figure 1, choose Other Account Type, Other Current Asset, and then click Continue.
  4. Assign an Account Name such as Contributions from Owner, (and account number if applicable). If necessary, click Subaccount Of, and specify the Deposits account. Click Save and Close to save the new account.

Recording Infrequent Transactions In Quickbooks

Figure 1: An easy way to manage security deposits is to post them to a new Other Current Asset account.

Refunds from utility companies, insurance companies, or other sources

Choose Banking, and then Make Deposits. Specify the vendor, and then choose the account. In the case of deposit refunds, you should have an asset account that you’ll apply the money against, as shown in Figure 2. For other types of refunds, use the expense account from which you originally paid the money.

Recording Infrequent Transactions In Quickbooks

Figure 2: Apply utility deposit refunds back to the deposit account on your balance sheet.

Owner Contributions

This is a situation where an owner of the company invests money into the firm. The owner does so in hopes of making a return on their investment, but does not have a specific timetable in mind for repayment of the loan. If you don’t already have a Contributions from Owner account, follow these steps described previously for creating a new account, but choose Equity and name the account Contributions from Owner.

Distributions to Owner

Distributions allow an owner to take profits out of the company on a non-salary basis. Distributions can be paid through payroll or on a separate check. Your chart of accounts should already include a Distributions to Owner account, but if it doesn’t, you can establish this new Equity account, which you can then use in either of these types of transactions.

  • Payroll: Distributions require special treatment in payroll because they’re not subject to income or payroll taxes in QuickBooks. The owner settles the income tax due when filing their annual return. Before you can pay distributions through payroll you must establish a payroll item. To do so, follow these steps:
  1. Choose Employees, Manage Payroll Items, and then New Payroll Item.
  2. Choose Custom Setup, and then click Next.
  3. Choose Addition, and then click Next.
  4. Enter the word Distribution and then click Next.
  5. Choose the Distributions to Owner account from your chart of accounts, and then click Next.
  6. Choose None for the Tax Tracking type, and then click Next.
  7. Leave all of the taxes unselected, and then click Next.
  8. Choose Calculate This Item Based on Quantity and then click Next when the Calculate Based on Quantity screen appears.
  9. Accept the default choice of Gross Pay and then click Next.
  10. Leave the Default Rate and Limit fields at zero and then click Finish.

Next, select the employee in the Employee Center, and then choose Edit Employee. Choose Payroll and Compensation Info from the Change Tabs list, and then add Distributions to the Additions, Deductions, and Company Contributions list, as shown in Figure 3. You can fill in the distribution amount now if you know the ongoing amount, or you can fill it in on the fly during the payroll process. Simply display the Paycheck Detail during the payroll process to access this field and enter the distribution amount.

Recording Infrequent Transactions In Quickbooks

Figure 3: Add Distributions to the Additions, Deductions, and Company Contributions section.

  • Separate check: A much simpler approach is to write a separate check to the owner. To do so, choose Banking, and then Write Checks. Choose the Distributions to Owner account and fill in the amount.
Loans to the Company

From time to time the owner may need to make a loan to the company. If the owner expects this money to be repaid, establish a Loan account on the chart of accounts and record the deposit of the loan to this new account.

Company Loans Money to Others

Sometimes your company may make a salary advance to an employee, or the firm may loan money to an affiliate. In such cases it’s important to always establish a separate Current Asset account for such transactions so that you can easily track the outstanding balance. Such accounts can be a subaccount of a general Loans Receivable account, as shown in Figure 4. As shown in Figure 5, you’ll code the check to that subaccount.

Recording Infrequent Transactions In Quickbooks

Figure 4: Make sure to create individual subaccounts for loans to employees or other parties.

Recording Infrequent Transactions In Quickbooks

Figure 5: Be sure to use the proper subaccount when issuing an employee loan.

Loan Payments

Many users struggle with loan payments because there are usually three different scenarios:

  • Interest only payment: In this case there’s only one account to charge, which will be Interest Expense, as shown in Figure 6.
  • Interest and principal payment: If you’re amortizing the loan over time – your payments include principal and interest – then you’ll have to charge two accounts on the transaction, both the Interest Expense and the Loan account itself, as shown in Figure 7. These amounts will be different each month. Your lender can provide amortization table, or you can search for one for free on the Internet. Simply use the search term “amortization table” to uncover a variety of free resources, or use this search term to locate an Excel-based solution: “amortization table site:microsoft.com”
  • Extra principal payment: Extra principal payments being submitted on a separate check should be applied directly to the Loan account.

Recording Infrequent Transactions In Quickbooks

Figure 6: Interest-only loan payments post directly to the Interest Expense account.

Recording Infrequent Transactions In Quickbooks

Figure 7: Make sure to break out principal and interest when a loan payment reduces the outstanding balance.

Expert tip: You can use the QuickBooks Account Reconciliation feature to reconcile your loan balance with the periodic statement that you receive from your lender. This ensures that your financial statements are correct, and helps you confirm that the lender is applying your principal payments correctly.

Petty Cash

Many offices keep a small amount of cash on hand to simply accounting for activities like running to the post office to buy stamps or make small purchases for the office. To establish a petty cash fund, you first write a check to Cash, which you then exchange for money at your bank. Let’s say that you establish a $100 petty cash account,
and need to replenish it to cover three purchases:

  • Lunch for the office: $24.72
  • Postage stamps: $44.00
  • Office supplies: $23.18

In QuickBooks, you would choose Banking, Write Checks, and then write another check to Cash, and code it to the corresponding expense accounts for the three purchases.

Expert tip: Petty cash is easily subjected to abuse, so be sure to require receipts for all petty cash transactions.

Ask a Question

Find comfort in knowing an Expert in accounting is only an email or phone-call away.

We Are Here to Help

We will happily offer you a free consultation to determine how we can best serve you.

Blog

Attestation Services: Compilations, Reviews, and Audits CPAs offer attestation services as unbiased options

frequently asked questions

  • What Is A Virtual CFO & How Can It Transform My Business?
    • a. A Virtual CFO can be a much-needed sounding board, coach, and guide. Outsourced Virtual CFO is generally not just one person, but an experienced team of professionals providing a full-stack Accounting and Finance Department at a fraction of the cost that it would otherwise cost a business to hire even just one full-time CFO internally. The right virtual CFO service team, such as the one at Perpetual CPA, can deliver timely, detailed, comprehensive financial reporting, interpret the financial data, prioritize recommendations, give expert guidance on how to execute those recommendations, and ultimately give a better path to business success.
  • How can a Virtual Accounting Department help small businesses scale and grow?
    • a. A growing number of small businesses are opting to outsource services such as IT, human resources, or accounting. The benefit of a Virtual Accounting Department is that the company can reduce or increase services to accommodate current business needs. Because the service provider has multiple clients they can absorb fluctuations in workflow more easily than the average small/medium business can on its own.

      b. A Virtual Accounting Department can integrate with a company’s own accounting department to create a blended solution or provide a full-stack accounting department, including Accounting Staff, Manager, Controller, and Virtual CFO. By using a Virtual Accounting Department Small business owners don’t have to worry about hiring, training, figuring out compensation, and payroll compliance for the internal accounting team. Also as the business grows and new and more complex accounting and tax issues come up, the outsourced Virtual Accounting Department can provide all the needed expertise to facilitate continued business success.
  • What are the benefits of hiring a CPA firm?
    • a. Certified Public Accountants (CPAs) do a lot more than just crunch numbers and prepare taxes. They provide valuable expertise and strategies to help businesses and individuals achieve their business and financial goals. A CPA firm can help small businesses with management financial reporting, tax compliance, strategic business advice, and much more. Firms like Perpetual CPA, that specialize in helping small and medium-sized businesses achieve growth, can also provide Virtual CFO services, that help the business owners have the foresight into the short-term future cashflows and be able to more successfully navigate their business performance.
  • What are the best strategies for small business growth?
    • a. A business growth strategy is, simply, a plan of how a business gets from where it is today to where it wants to be in the future.

      b. Some of the questions to consider when coming up with a growth strategy are:
      i. Where will the business get new customers from?
      ii. How will the business expand into new markets?
      iii. What new products could the business offer?

      c. In reality, what happens with many small businesses, is that they generally achieve a specific level of business activity or sales and then the business growth trend flattens. In those cases, working with a firm like Perpetual CPA, which provides Virtual CFO services, can help small businesses avoid stagnation. Virtual CFO services, aside from providing timely accounting and tax reporting, can also provide valuable insight into the current performance of the business, as well as, foresight into the future cash flows for the business. Perpetual CPA Virtual CFO team helps small businesses interpret their financial information and come up with business strategies to help improve business performance and achieve growth.
  • What are the best strategies for small business risk management?
    • a. A risk management plan helps a business develop a detailed strategy to deal with certain risks that are particularly important for the businesses’ success.

      b. For many small and medium-sized businesses, the easiest way to develop and implement a business risk management plan is to work with a reputable CPA firm, such as Perpetual CPA. Large corporations invest a lot of resources and time into managing risk, which is a material factor that allows those large corporations to continue to generate billions of dollars in revenue every year. Small businesses, however, almost never manage any business risks, which is the major reason that over half of all the small businesses do not survive for more than 5 years. Generally, small business owners are not experienced corporate business professionals and lack the needed business knowledge, yet they often have to wear many hats while trying to get their businesses off the ground. In those situations, a CPA firm such as Perpetual CPA, can help small businesses better manage tax compliance risks, cash flow, internal controls, business administration, financial reporting, and much more.
  • What is Strategic Advisory and Virtual CFO? / How do Strategic Advisory and Virtual CFO services work?
    • a. When small businesses start spinning wheels, it is a good time to consider hiring a reputable CPA firm, such as Perpetual CPA, which can provide both Strategic Advice and Virtual CFO services.

      b. As a strategic advisor, the CPA firm will work with business management to improve the effectiveness and profitability of the business. They will look holistically at the business and find ways to operate the business more efficiently, increase customers through additional or improved marketing or improve customer touchpoints and service.

      c. As a Virtual CFO, the CPA firm is like a part-time version of a traditional CFO or Chief Financial Officer plus a full Accounting support team. They perform the tasks that in a larger organization would be performed by the CFO, Controller, and Accounting Staff such as preparing and overseeing the budget process, identifying and analyzing current and future trends, and developing strategies for the business growth.
  • How can timely financial visibility and management reporting help with better business decisions and growth?
    • a. A simple way to a successful business is to prioritize the timely financial visibility and management reporting as it means:
      i. Timely financial information and analysis are essential for making informed decisions, evaluating your company’s results, improving financial performance, and ensuring you are on the path to meet your strategic goals.
      ii. Management reporting is a source of business intelligence that helps business leaders make more accurate, data-driven decisions. But, these reports are most useful if they are available timely and the management receives proper interpretation of the business financial information.

free initial 30-minute consultation

    © Perpetual CPA 2020   •   Site Map   •   Privacy Policy   •   Disclaimer   •   Powered By   Designed by Dot Com Media Moguls