If you're looking for an efficient way to track your company's expenses, then this is the right article for you! Accounts payable is an accounting term that refers to money owed by a company or individual to suppliers or others who have done business with them. It may also refer to money owed by the company, business owner, or individuals.

Using an accounts payable aging report can help business owners manage their books. It's a valuable tool for tracking the amount of expenses paid versus owed. And, it helps provide insight into when payments are overdue and the steps needed for them to be paid off in full.

How to use an Accounts payable Aging Report in QuickBooks Online

A QuickBooks Online aging report is like having a money management dashboard in your hand. In the next section, we will show you how to set up the aging report. The aging report allows you to view your Accounts payable balance as of any specific day or date (or range of dates). Using the Aging Summary Report below, helps identify accounts payable amounts over 30 days old for your review.

These are the steps you'll need to take to run an Accounts payable aging report:

1) Left-hand side > click on Reports > In the search bar in the upper right-hand corner, type in "Accounts payable" and select either Accounts payable aging summary or Accounts payable aging detail > in this example, we will be choosing the Accounts payable aging summary

2) On the next page > filter for date. For instance, you can choose either "Today" or a specific date range. With date range selected > click "Run Report" located on the right-hand side.

3) To view the amounts owed > click directly on the vendor names or the dollar amounts. For this example >click on "226" owed to "Jennifer Hargreaves."

If you want to change the filters, you can click on the report's gear icon "Settings" at the top right-hand corner. Doing this will open a new window with additional information on the amount owed. Once you've selected your filters, select "Next" again.

4) The last steps include:
-        Saving or exporting the data that you want to analyze
-        Correcting amounts or applying vendor credits, or payments against the amounts
-        Following up with the vendor, paying the vendor, or agreeing to a payment plan

Related Articles: 8 Tips to Improve Your Bookkeeping & Processes for Accounts Receivables

Frequently Asked Questions

What's the value of running an accounts payable report?

The value of running an accounts payable report is that it provides you with a snapshot of your company's financial performance. The aging process, which we will go over below, will allow you to compare the amount owed versus the amount earned. This provides a baseline for outstanding payments and their percentage of revenue and earnings and will enable you to determine if any trends are developing that may be worth further investigation.

From there, it's an easy step to determine if additional steps are needed for payments to be started or if they are overdue.

Are there any risks with not looking at an accounts payable report regularly?

As an owner, an accounts payable report can help you make better decisions about managing your company. There are circumstances where you might owe money that you usually wouldn't notice because you don't have access to reports tracking this data. It's important to note that this is a risk if you don't have the money to pay off your outstanding balances. This is why it's critical that you understand the value of having an aging report.

For example, an aged accounts payable report might show a series of overdue payments or payments held up. This could be for various reasons, one being the late payment fee. It's helpful to understand what is causing these payments to be late or why they aren't paid off on time to avoid incurring additional fees or penalties on your end. If you're looking for ways to save on your business expenses, this can help you determine where you're losing money and how you can avoid it in the future.

What do I need to know before starting an accounts payable aging process?

You want to make sure you understand what the aging process entails and how it will help your company understand your revenue and expenses.

What do I need to know before starting an accounts payable aging process?

You want to make sure you understand what the aging process entails and how it will help your company understand your revenue and expenses.

How often should I run my accounts payable report?

You must run an accounts payable report regularly to know your outstanding balances. Ideally, you would be running an accounts payable report at least once a month to ensure that you do not have too many outstanding payments or pay too much in interest.

Having this information at your fingertips is critical for your company's finances. Ask yourself these questions about your business:

-        Are there any trends of overdue payments or delayed payments?
-        Are any payments being held up?
-        How much are you paying in interest?
-        If there are unpaid balances, have you considered paying them off early to save money on interest costs?

When you are managing a business, it’s important to stay organized. One example of this is the accounts payable aging report in QuickBooks Online, which will let you view your payables status and the amount that the business owes over various time frames. It simplifies everything into a single document—or spreadsheet, as we would usually call it—that shows you how much money your business owes.

Not sure where to start?

Get in touch with us today. We can help you find the answers to these questions and have the correct information to make intelligent business decisions.

Looking for bookkeeping in Ottawa? Learn more about our services and our team.


If you don't know your accounts receivable process inside and out, it doesn't matter how good a salesperson you are. You can be on top of your game day in and day out, but until you figure out how to manage the process that comes after the sale, and the bookkeeping that goes with it, you're never going to be able to grow.

When it comes to the accounts receivable process, there are a few things that you need to know about to improve your workflow. Those are:

  1. How Long It Takes You To Get Paid
  2. What your payment terms are
  3. How Much Money Is in the Cycle When It Comes To Getting Paid?
How Long It Takes You To Get Paid

When you're trying to improve your accounts receivable process, the first thing you need to look at is how long it takes for invoices to go unpaid once sent out. If you're in constant contact with customers and customers who have previously purchased from you, you probably know that it takes about 30 days or so for them to pay your bill after the fact.

What does this mean for you? When was the last time that your customers paid what they owed? If you haven't checked in on it in a while, stop and do so now. Has it been more than 30 days since they paid? Then you need to adjust how long the process takes. If it's taking longer than 30 days, you need to try and require that they pay earlier in the cycle. If it's taking less than that, you should probably consider a way to speed the process up.

What Your Payment Terms Are

There are many different kinds of payment terms that you can offer your clients. Some require no money upfront, while others require full payment before any work goes out. Whatever payment terms you decide to go with, it should be something that makes sense based on your industry and what your clients are willing to agree to.

What does this mean for you? The payment terms that you offer should be something that your clients are willing to agree to. If they aren't, you need to think about changing the terms until you find something that both of you can agree with. This is one of those things where if you settle, all parties come out unhappy.

How Much Money Is in the Cycle When It Comes To Getting Paid?

If you're wondering how much money should be in various stages of the accounts receivable process, here is a rough outline:

Invoices – No money should be sitting at this stage at any time.

Credit Card Payments – This depends on your credit card processor. Most chargebacks are handled by the merchant, with the processor handling disputes.

Payment Schedules – This is the timeframe in which payments should be due. It's essential to know your customers and their payment schedules so that you can create a timetable for when their payments should be received.

Payments – Once they're received, this is how much money you get. Some companies may only allow for partial payments or require an entire payment to come in before they pay anything out.

What does this mean for you? If you've been paying your company's bills, you should know how much money is sitting in each of these stages. Once you do, you can work on optimizing the bookkeeping process based on this information.

Luckily, there are some tried-and-true ways to improve your bookkeeping process that anyone can implement with some deep thought and some elbow grease.

Here are Elevate by Welch’s 8 tips to help you get started:

1. Determine the optimal collection process for your business

First, figure out what sort of collection process will work best for your company. Do you need to offer customers a series of payment plans? Will it be better to take a more aggressive stance and set firmer deadlines? There are several factors involved in making this decision, but the most important is your customer base. Are they capable of handling a complex AR system, or is it better to keep things simple? The answer will vary by industry, but most businesses find they can remain competitive with straightforward policies and minimal stress on the AR side.

2. Establish a payment due date

Once you've determined how aggressively to pursue the AR process, the next step is to set a payment due date. This can be helpful if you're offering customers an extension since it will help them understand when they should expect to pay off their balance. You may still wish to provide some payment plan or extension in certain situations, but having an official due date in place can help prevent undue stress for all parties involved.

3. Utilize email reminders when necessary

If your customers fail to make payments by the due date, it's time for a gentle reminder via email. You can't be too pushy or hound your customers via email. However, politely asking for payment by a specific date can be effective at getting some customers to pay up on time. Keep in mind that some customers will need more time, but others are perfectly capable of paying up without much hassle.

4. Offer payment plans when necessary

For some customers, establishing a due date isn't enough to get their payments in on time. If you need to offer payment plans on occasion, don't hesitate to make it clear how these plans work and whether there is any penalty involved if the customer doesn't pay off the balance in the allotted amount of time.

5. Evaluate and adjust your collection process as needed

If you find you need to change your AR collection policy or procedure, be sure to evaluate the situation and make necessary adjustments as necessary. For instance, you may find that a more aggressive approach works better than a more laid-back approach if your customers are slow to pay off their balances. Make the changes accordingly and continue trying new strategies until you find one that works best for your company.

6. Assess your operations with regards to AR processes and controls

As part of an overall systems audit, assessing how effective and efficient the account receivables process is within your company is explicitly also beneficial. What are the strengths and weaknesses of this process? What process improvements can you make to improve collections? By looking at these questions objectively, you can use this information to refine your AR process even further.

7. Automate your AR processes where possible

If you have the resources, it can be helpful to automate your AR collection process as much as possible. This is because automation simplifies the collection process considerably, allowing you to collect payments with ease and ensure that all documentation is readily available for auditing purposes if necessary

Check out some automation tools for this like AR Collect or Chaser

8. Give customers an incentive to pay off their balance.

As a final tip, remember that you can also give customers an incentive to pay off their balance as quickly as possible, so long as it doesn't run afoul of the law. You can offer discounts or other perks for specific customers who are willing to pay off their balance within a specified time frame. This will save you money in the long term, and it's likely to appeal to customers looking for a deal.

Over time, you'll find that your AR management strategy becomes more streamlined and efficient with every improvement you make. This leads to greater profitability over time, resulting in overall business success.

Not sure where to start? Get in touch with us today. We can help you find the answers to these questions and more so that you have the right information to make smart business decisions. Want to know more about hiring an Elevate cloud-bookkeeper and how they can help improve your bottom line - check out Anita's piece here.

Caroline Proulx, Onboarding Manager at Elevate by Welch , is a compassionate leader and is always eager to support her community. With the aim to support both families in need as well as local businesses, Caroline organized the Meals that Heal campaign with Naturally Vero, a local vegan café and food delivery service.

Caroline says she has always wanted to get involved with the Ronald McDonald House Charities. “I knew about the Meals that Heal program from when I stayed at the Ronald McDonald House in Toronto many years ago,” Caroline tells us. “Many families are required to travel in order for their children to receive medical care and this can be very stressful, emotionally and financially.”

The National Capital Children’s Oncology Care Inc. Manoir Ronald McDonald House Ottawa has opened its doors to sick children and their families since 1984. They are dedicated to providing a warm, safe, affordable and compassionate environment for families of seriously ill children receiving medical services.

Elevate by Welch’s Meals that Heal program helps relieve families from a stressful night of cooking. Having a sick child can be extremely draining, and the Meals that Heal program takes away the worry of having to create a healthy home-cooked meal for the whole family. Meals that Heal allows members of the community to support these families. RMHC – Ottawa normally opens up their kitchen to the volunteers to prepare a dinner or brunch for up to 30 people. However, there were some changes required due to the pandemic.

“Covid-19 did interfere with how the Meals that Heal program was intended to work,” explains Caroline. “Prior to Covid-19 restrictions, a group would cook the meals for the families in the RMHC kitchen. Due to the restrictions we could only drop off the meals and we were not able to interact with the families.”

Caroline contacted an Ottawa-Gatineau business community stalwart - Veronique Daoust – chef and owner of Naturally Vero, with the hopes of collaborating on this community-driven campaign. Naturally Vero has been a business leader in the Ottawa-Gatineau community for a number of years.

“It seemed like a perfect fit: to be able to partner up with a business leader who crafts wholesome meals that fill the heart as well as the stomach,” says Sean Duffy, Senior Manager at Elevate by Welch.  

Together, Caroline and Veronique wanted to do something to give back to the community during the holiday season.  They wanted to create a meal that was healthy and also comforting for the families staying at the RMHC – Ottawa; it was important to provide a nutritious meal to the exhausted families. “My personal story and the stories of countless families that benefitted from RMHOTT and the staff – inspired Naturally Vero to craft something special,” adds Caroline.

December 30th, 2020 was a cold, quiet winter day. The team at Naturally Vero organized the meal prep at their café located in Chelsea, Quebec. Veronique and Caroline were thrilled to personally deliver the meals to RMHC, despite not having the opportunity to meet and interact with the families at RMHC due to COVID-19 restrictions. The menu for the evening was created specifically for the families at RMHC and the theme was health and comfort. The starter was a Butternut Squash & Sage soup. The main course was a Vegetable Lasagna served with Maple Balsamic Roasted Root Vegetables and a Spinach Pear Salad. Naturally Vero also included a bright yellow lunch box for every meal.

Pictured above: Butternut Squash & Sage soup, main course of Vegetable Lasagna served with Maple Balsamic Roasted Root Vegetables, and a Spinach Pear Salad.

Elevate by Welch and Naturally Vero intend to continue running this campaign each quarter. “We want to be a presence and an expectation for the families that are staying at RMHOTT – and help to lift some spirits along the way,” says Veronique.

If you want to get involved with helping RMHC Ottawa, visit their website and check out the Get Involved page. They have a number of ways you can help. Once the Covid-19 restrictions lift, Caroline and Veronique will need the help of some volunteers to assist in making dinner for the families at RMHC - Ottawa.  

If you want to know more about how you can help, please reach out at cproulx@welchllp.com

COVID-19 and working from home. Some feel strongly about it, others not so much. The CRA has released guidance on the home office expenses deduction that employees may claim on their 2020 personal income tax return (T1) because of the COVID-19 pandemic.  

How does it work? Read on to find out, and feel free to reach out to your Elevate by Welch professional to learn more and ensure you optimize your 2020 tax return. 

Eligibility

To claim a home office expenses deduction, you must meet all of the criteria:

The CRA has also published a number of resources to assist both employees and employers, including

Two available options

If you meet the eligibility criteria, you have two options to calculate the deduction for home office expenses:

Employers may suggest a method for their employees. It is the employees who have the ultimate authority to choose which method to use.

The CRA has designed a calculator (specifically to assist with the calculation of eligible home office expenses).

Temporary flat rate method

What is it?

If you worked more than 50% of the time from home for a period of at least four consecutive weeks in 2020 due to COVID-19, you can claim $2 for each day that you worked at home up to a maximum of $400 (200 working days) per individual.

If working at home and claiming home office expenses was the norm for you pre-COVID-19, you cannot use the temporary flat rate method to complete your 2020 claim. 

What counts as a work day?

Days you worked full-time hours, overtime-hours or part-time hours from home.

Days that cannot be counted: days off, vacation days, sick leave days, other paid or unpaid leave of absence.

Do I need from my employer a certified Form T2200 Declaration of Conditions of Employment or Form T2200S Declaration of Conditions of Employment for Working at Home Due to COVID-19?

No.

Do I need to retain documents in support of my claim?

No.

How to claim?

You would need to complete the “Options 1 – Temporary flat rate method” section on Form T777S Statement of Employment Expenses for Working at Home Due to COVID-19.

Is the deduction calculated by the individual or by the household?

Each employee working from home who meets the eligibility requirements can use the temporary flat rate method to calculate his/her deduction. If there are more than one eligible employee working at home in the same household, each can choose his/her method to calculate the deduction.

What types of expenses are covered by the $2 flat daily rate?

The temporary flat rate method is used to claim home office expenses that you paid like rent, electricity and home internet access fees, as well as office supplies like pens and paper, and cell phone minutes.

Under this method, you cannot claim any other type of work-space-in-the-home-expenses,  home office expenses or costs for items purchased of a capital nature. 

Can I claim any other employment expenses?

No, you cannot claim any other employment expenses such as allowable motor vehicle expenses, parking, travelling expenses, etc. 

Is the up-to-$400 a credit or a deduction?

Home office expenses can be claimed as a deduction on an employee’s personal income tax return. A deduction reduces the amount of income they pay tax on, so it reduces their overall income tax liability.

Will the temporary flat rate method be extended past 2020?

No. The temporary flat rate method only applies to the 2020 tax year.

Detailed method

What is it?

If you meet all of the criteria listed above under the “Eligibility” section, you may use the detailed method or the existing method to deduct home office expenses. 

Do I need a certified Form T2200S or Form T2200 from my employer?

Yes.  

Form T2200S is a new simplified form for employers to complete and sign for employees who meet the eligibility requirements and who choose to use the detailed method.

If an employee pays for other employment expenses, such as allowable motor vehicle expenses, parking, travelling expenses, the employer must complete the traditional Form T2200.

For 2020 only, the CRA will accept an employer’s electronic signature on Form T2200S or Form T2200.

Do I need to retain documents in support of my claim?

Yes. Generally, you must keep all required records and supporting documentation for a period of six years from the end of the last tax year they relate to.

How to claim?

You can claim the actual working-at-home eligible expenses you paid that are supported by documents. Eligible expenses will be detailed out in the “Options 2 – Detailed method” section on Form T777S Statement of Employment Expenses for Working at Home Due to COVID-19.

How to determine the employment use of work space?

Whether you work in a spare room exclusively used as your work space at home, or at the dining table sometimes or at the kitchen table other times, there are several factors to consider when calculating the employment use of the work space at home, for example:

The CRA may accept a method of calculation other than one based on square meters (feet), as long as you are able to demonstrate to the CRA that your calculated percentage of use is reasonable.

What are eligible expenses?

Commonly seen eligible work-space-in-the-home expenses and other home office expenses include:

The CRA has expanded the list of eligible expenses that can be claimed to include home internet access fees.

Note that salaried employees cannot include the expenses paid pertinent to home insurance, property taxes and mortgage payments (principal and interest) in calculating the home office expenses.

Can I claim any other employment expenses?

If you are eligible to deduct home office expenses by meeting the requirements listed in the “Eligibility” section above, you would use T2200S and T777S forms to complete the claim. You cannot claim other employment expenses such as allowable motor vehicle expenses, parking, travelling expenses, etc. 

If you are eligible to deduct home office expenses by applying the traditional criteria, which are outlined in the CRA Guide T4044 Employment Expenses, you would use T2200 and T777 forms to complete the claim. You can claim other employment expenses such as allowable motor vehicle expenses, parking, travelling expenses, etc.   

Home Office Equipment up to $500

The CRA has expanded its previous position (2020- 0845431C6 (F)) on employer reimbursement of personal computer equipment to include home office equipment. In the COVID-19 context, the CRA will not consider an employee to have received a taxable benefit where their employer pays for or reimburses up to $500 of computer or home office equipment that enables the employee to carry out their employment duties by working at home. To be treated as a non-taxable benefit, the employee must submit receipts to the employer. The CRA indicates that home office equipment would include items such as desks or chairs.

Jessica Zhang-Chapman, CPA, CGA, CIA, of Welch LLP illustrates it perfectly with a great example: 

“ For example, if an employee purchased a second computer monitor for $300 plus an adjustable desk for $400, and the employee submitted receipts in support of the purchases, an employer can reimburse the employee up to $500 without the employee receiving a taxable benefit under the CRA administrative policy in the COVID-19 context. If the employer reimburses the full $700 for the purchases, the amount over $500 (that is, the $200) must be included in the employee’s income as a taxable benefit”

Parsing through tax guidance can be daunting. If you are unsure of where to start, need help moving it along, or want to entrust us with your personal taxes, please reach out to us at sduffy@welchllp.com

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram