bowtie_david
Level 2
‎October 07, 2021 02:00 PM

Payment terms - net due the 15th of following month

I'm being asked to set up terms in Quickbooks Desktop and need some help getting it right.

For example: All invoices created in January should show a due date of February 15th, regardless of what day in January they were created. So when we print statements on February 1st, anything from January would show in the "Current" due column, and anything before January would show 1-30 days aging, etc...hope that makes sense.

I tried setting this up as date driven, Net due before the 15th, due next month if issued within 15 days of due date... but that didn't have the expected outcome. Invoices that should have been in the Current column were showing 30 days past due. Help!?

Solved
Reply Join the conversation
BigRedConsulting
Community Champion
Community Champion
‎October 07, 2021 02:19 PM

Payments

I set the terms up as I figured I should and it worked perfectly. Then I saw your screenshot - which is exactly how I set up the terms I tested with. What doesn't work when you try it on an invoice?

 

Note you can turn on the due date field in the layout designer so you can see what it's doing. As I adjusted the invoice date, the terms updated just as requested. They should for you as well:

 

Capture1.JPG

Capture2.JPG

View solution in original post

Reply Join the conversation
bowtie_david
Level 2
‎October 07, 2021 02:57 PM

Payments

I tried again and it does show correctly for me as well. Our A/R person said the other day that when she printed statements, the Currrent, 30 days past due, etc... columns were not accurate and I thought I had checked that too, but in any case, this does seem to work as you described. Thanks for confirming that the setup is correct. I'll check the statements at the end of this month and see if maybe she's doing something wrong in the statement window. Thanks again!

Reply Join the conversation
BigRedConsulting
Community Champion
Community Champion
‎October 07, 2021 05:21 PM

Payments

Note that if you use the terms on invoices and then edit the terms record, the due dates on existing invoices won't change. Could that be what you're seeing?

 

If you have invoices with incorrect due dates, you can fix them now by editing them, changing the terms item, and then changing it back.

Reply Join the conversation
Fiat Lux - ASIA
Level 15
‎October 07, 2021 05:34 PM

Payments

@bowtie_david 

Are you using QBD Pro/Premier? How big is the file size? Run the Verify/Rebuild Data utility to check your file.

Reply Join the conversation
ctrav21
Level 1
‎June 19, 2025 08:05 AM

Payments

I have a follow up question pertaining to this. I did set up terms the same as the OP and the date due (15th of the month) is showing correctly on the customer statement. However, I am having an issue with invoices entered at the beginning of the month showing up at the bottom of the statement in the 1-30 Days Past Due box?

 

For example: Invoice entered on 6/5 for $20.61, Statement dated 7/1, Due 7/15 is showing the $20.61 in the 1-30 Days Past Due Box, but it is not actually past due until after the 15th of July.

 

Any input on what I can change to fix this? 

Reply Join the conversation
bowtiestudio
Level 2
‎June 19, 2025 10:54 AM

Payments

Hi @ctrav21 , 

Just a guess here, but since the earlier in the month invoice is the one showing up in 1-30, I wonder if that invoice was created before the terms were set? Piggybacking off of what @BigRedConsulting said about term changes not retroactively changing due dates on existing invoices... Does your Invoice template show the Due Date? and if so, does the due date on the invoice itself reflect the terms set?

Reply Join the conversation