United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
dave203
Level 1
posted
‎January 13, 2022 01:58 AM
last updated ‎January 13, 2022 1:58 AM

How do I set up a Terms entry in QBO that makes the Due Date the last day of the month following the Bill or Invoice's date?

Using 30 days for each field under "Due by certain day of the month", I am currently capturing bills for January that are showing the due date as 2nd March instead of 28th February.
Solved
Reply
Best answer January 13, 2022
Solved

Best Answers
Giovann_G
Moderator
Moderator
‎January 13, 2022 03:18 AM

How do I set up a Terms entry in QBO that makes the Due Date the last day of the month following the Bill or Invoice's date?

Welcome to the Community, dave203.

 

Setting the due date to the end of the month isn't possible when using the 30 days term. I'll share a method so it shows the last day of the month.

 

Here's how:

 

  1. Go to the Gear icon, select All lists.
  2. Click Terms, then New.
  3. Enter your desired name, In the Due by certain days of the month enter 31.
  4. In the next box Due the next month if issued within input 31.
  5. Once done, hit Save.

 

I've also included the following articles below to help you manage your sales form:

 

 

Let me know if you need further assistance about managing terms in QuickBooks Online. We're always available anytime.

View solution in original post

Reply
4 Comments 4
Giovann_G
Moderator
Moderator
‎January 13, 2022 03:18 AM

How do I set up a Terms entry in QBO that makes the Due Date the last day of the month following the Bill or Invoice's date?

Welcome to the Community, dave203.

 

Setting the due date to the end of the month isn't possible when using the 30 days term. I'll share a method so it shows the last day of the month.

 

Here's how:

 

  1. Go to the Gear icon, select All lists.
  2. Click Terms, then New.
  3. Enter your desired name, In the Due by certain days of the month enter 31.
  4. In the next box Due the next month if issued within input 31.
  5. Once done, hit Save.

 

I've also included the following articles below to help you manage your sales form:

 

 

Let me know if you need further assistance about managing terms in QuickBooks Online. We're always available anytime.

Reply
dave203
Level 1
‎January 13, 2022 06:11 AM

How do I set up a Terms entry in QBO that makes the Due Date the last day of the month following the Bill or Invoice's date?

Tested and your solution works perfectly. The "trick" is to use 31 days to represent a month and not 30 days.

Thank you.

Reply
kmsbservices-out
Level 1
‎January 04, 2023 10:48 PM

How do I set up a Terms entry in QBO that makes the Due Date the last day of the month following the Bill or Invoice's date?

I created a new Term called 'End of Next Month' and followed your advice regarding Due By and Due the Next Month by entering 31 in both fields.  When I create an Invoice or Bill that is dated the 31st January, the due date of the Bill or Invoice comes up as 31st of March.  It should be 28th February. Please help.

 

Reply
Charies_M
Moderator
Moderator
‎January 05, 2023 12:30 AM

How do I set up a Terms entry in QBO that makes the Due Date the last day of the month following the Bill or Invoice's date?

Good day, kmsbservices-out.

 

There are two options when setting up terms in QuickBooks Online (QBO), the Due in fixed numbers of days and the Due by certain day of the month. Since the bill's due date shows up as March 31st, it's possible that the later option was set up. This is the reason why the date jumps up to March 31st  because there's no 31st in February.

 

If you wish to show Feb 28 as the due date, you'll want to create separate term that will fall for that certain date.

 

I've attached a sample screenshot that you can refer. It shows that the Due in fixed number of days option is used indicating 28 as the fixed number.

 

In case you encounter inconsistencies in due date and invoice dates, feel free to check out this article for troubleshooting options: Fix inconsistencies in due date and invoice date in QuickBooks Online

 

Visit these easy-to-access articles, webinars, and video tutorials that will help you in familiarizing the different tasks, features, and functions of QBO.

Of course, you're always welcome to visit us again if you need help while working with terms in QuickBooks. It will be my pleasure. Stay safe and have a great day ahead!

Reply