Solved

Projects with deposit/prepayment


Userlevel 7
Badge +9

I would like to setup the Project module to track our consulting projects, most of which are prepaid. For example, let’s say we invoice a customer for 8 hours of work. I would like this to show up as a liability in our GL and project.

As our consultants work on the project, I would like the project billing to automatically deduct from the prepaid amount and to generate a $0 invoice. Can this be automated? It doesn’t look like you can have an allocation or billing rule that looks at the balance of another account group in the formula, so I’m not sure it is possible. The expectation is that consultants will not go over the number of hours that have been sold without an approval so I would actually be fine having to look at a custom report that shows projects that are over budget… 

Guidance/advice from project experts is appreciated 😊

P.S. there should be a “Project” sub forum on this community!

icon

Best answer by Gabriel Michaud 7 March 2022, 14:45

View original

5 replies

Userlevel 1
Badge

Hi Gabriel

 

I am trying to solve a similar but slightly different problem where a PO is provided by a customer for work on multiple projects and I need to track the balance of the issued PO across the projects. 

 

For your challenge, and I am sure you have thought of it, could you process the prepayment as a payment on account for the client. And then add the pre-paid hours to the project budget and set the project to not allow hours to be booked over budget. 

 

When the project invoice is raised you can settle it against the cash on account.

 

Thanks 

 

Matt

 

Userlevel 7
Badge +9

@mbrown30 I’m not sure using a prepayment is OK from an accounting standpoint, since we will be issuing an invoice (for tax purposes, but also because customers want to have one to pay). Also, accounting would need to make sure to check for prepayments before sending the invoices out every month, which is something I’d like to avoid.

My other idea is to build a customization that would look at the balance of a specific account group in the project during billing, and auto-add a line that will credit the amount on the invoice up to the deposit amount - but it’s something I’d like to avoid if possible :) 

Userlevel 2
Badge

Yes, what is the solution?  The AR prepayment document does not have any Project associated to it.

If you create an invoice, then you need to create a Credit memo to offsett the invoice just created.

 

The Proforma Invoice does not allow Prepayment.

 

The client requirements are;

  1. Create a document to send to customer to pay a deposit.
  2. This document should have visibility to the Project. ( AR payments and Prepayments do not).
  3. When the Time & Material Invoice is created, then have visibility of the amount of deposit to be applied

 

Userlevel 7
Badge +9

Hi @phillipmarotta,

I did not make any progress on this. I came to the conclusion that there is no out-of-the-box solution and that I would like to make custom development. We are managing this manually for now...

What we have done tackling this issue; we initially generate an invoice and change the credit term. We have configured a credit term that allows payments in installments. The installments are then invoices that are generated now but with monthly or annual due dates.

 

I hope this helps

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2022  Acumatica, Inc. All rights reserved