Jump to content
Sign in to follow this  

Account Statement Help!

Recommended Posts

Hi to all reading...

Well I'm pottering along with my own solution for invoicing and managing my business accounts ok here.

I'm wondering if I could have some help with creating an Account Statement Report for my clients, which depending on the client, is either issued monthly or quarterly.

The bit I'm stuck on is how to incorporate credits / deposits / overpayments into a running total.

On the onset of a contract, I always request a deposit (usually negotiated with the client before commencement, and is not a static figure or percentage), I then work that deposit off! Eventually their account reconciles and they begin paying an hourly rate.

So... Their statement needs to display an Opening Balance that is either in arrears, credit, or just a current balance as their latest invoice would show. Then a column on the report detailing the Invoices issued, against the payments received, and what the balance is. If they have made on Overpayment, I would like that credited to their next account.

I'm at a loss as to the best way to work the overall structure out here.

My invoices are working fine (without any credits / overpayments), and the setup is a Join Table of Invoices and Line Items, and I input data directly into the Invoice via Line Items portal.

Any ideas, or suggestions would be great :

Share this post

Link to post
Share on other sites


You would have to grab the invoice value to an AR (accounts receivable) Line via Script. How I usually do it is to create a Post button, so when you finished the Invoice you hit POST and a Script posts it into an AR Line. This can be balanced out much easier.

Hope I understood what you are trying to do.


Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.