LIMITED TIME 90% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
RossKline
Level 1

Reporting A Paid-in-full Expense Across Multiple Months

I have a client that pays their insurance in full because they get a discount, but wants the expense reported evenly across 6 months (the renewal period of the insurance). How do I do this?

 

For example: $300 paid on 01/01/2023, reported as $50 in Jan, $50 in Feb, and so on.

Solved
Best answer January 02, 2023

Best Answers
Tori B
QuickBooks Team

Reporting A Paid-in-full Expense Across Multiple Months

Good morning, @RossKline

 

Thanks for reaching out to the QuickBooks Community for support. I'm happy to lend you a hand with recording the prepaid expense. 

 

Before we begin, please know that it's always best to consult with your accounting professional before making any changes to your company file. If you don't have an accountant, don't sweat it. You can find one here in our Resource Center

 

First, you'll want to create an account to track the prepaid expense. Generally, this is an Other Current Asset account. Here's how: 

 

  1. From the Company menu, choose Chart of Accounts.
  2. In the Chart of Accounts window, right-click anywhere, then click on New.
  3. In the Choose Account Type window, select the Other Account Types drop-down, then tap on Other Current Asset.
  4. Hit Continue.
  5. Enter the Account Name (Example: Prepaid Expenses) and other details, then select Save & Close.

 

Once you've completed these steps, you'll need to enter the payment to the vendor using the newly created account. Then, you can create a memorized journal entry to allocate one month or a quarter of the expense. Here's how:

 

  1. From the QuickBooks Company menu, choose Make General Journal Entries.
  2. Enter the appropriate date for the first period. You can either use your own entry number or allow QuickBooks to auto-assign one.
  3. Debit the Expense account and credit Prepaid Expenses for the appropriate percentage of the total payment (1/6 if 6 months, ¼ if quarterly for a year). You can include an appropriate memo if you choose.
  4. Press Ctrl-M on your keyboard to memorize the transaction. Assign it a name (Example: Umbrella Insurance), and choose Automatically Enter. Choose how often you want the entry recorded and the date of the next transaction. Also, indicate the number of remaining entries.
  5. Hit OK.

 

Now that you've covered the Journal Entries, the entries will record according to the frequency you selected, reducing the Prepaid Expenses account each period. The balance in the Prepaid Expenses account should be zero at the end of the coverage period.

 

For additional details about this process, check out Record and allocate Prepaid Expenses

 

I'm only a reply away should you have any questions. Take care!

View solution in original post

2 Comments 2
Tori B
QuickBooks Team

Reporting A Paid-in-full Expense Across Multiple Months

Good morning, @RossKline

 

Thanks for reaching out to the QuickBooks Community for support. I'm happy to lend you a hand with recording the prepaid expense. 

 

Before we begin, please know that it's always best to consult with your accounting professional before making any changes to your company file. If you don't have an accountant, don't sweat it. You can find one here in our Resource Center

 

First, you'll want to create an account to track the prepaid expense. Generally, this is an Other Current Asset account. Here's how: 

 

  1. From the Company menu, choose Chart of Accounts.
  2. In the Chart of Accounts window, right-click anywhere, then click on New.
  3. In the Choose Account Type window, select the Other Account Types drop-down, then tap on Other Current Asset.
  4. Hit Continue.
  5. Enter the Account Name (Example: Prepaid Expenses) and other details, then select Save & Close.

 

Once you've completed these steps, you'll need to enter the payment to the vendor using the newly created account. Then, you can create a memorized journal entry to allocate one month or a quarter of the expense. Here's how:

 

  1. From the QuickBooks Company menu, choose Make General Journal Entries.
  2. Enter the appropriate date for the first period. You can either use your own entry number or allow QuickBooks to auto-assign one.
  3. Debit the Expense account and credit Prepaid Expenses for the appropriate percentage of the total payment (1/6 if 6 months, ¼ if quarterly for a year). You can include an appropriate memo if you choose.
  4. Press Ctrl-M on your keyboard to memorize the transaction. Assign it a name (Example: Umbrella Insurance), and choose Automatically Enter. Choose how often you want the entry recorded and the date of the next transaction. Also, indicate the number of remaining entries.
  5. Hit OK.

 

Now that you've covered the Journal Entries, the entries will record according to the frequency you selected, reducing the Prepaid Expenses account each period. The balance in the Prepaid Expenses account should be zero at the end of the coverage period.

 

For additional details about this process, check out Record and allocate Prepaid Expenses

 

I'm only a reply away should you have any questions. Take care!

nkrotzer
Level 1

Reporting A Paid-in-full Expense Across Multiple Months

Thank you for helping on this!  I am running into a problem and I'm sure it is simple, but How do we categorize this expense? If I put it in the desired category, it still shows the expense in one single month.  If i put it in "Prepaid expense" account that I created, I can't see where I can assign a category in the journal entry.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us