Jump to content

Account Statement Help!


Roxy201

This topic is 5960 days old. Please don't post here. Open a new topic instead.

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 :

Link to comment
Share on other sites

Hi,

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.

Ron

Link to comment
Share on other sites

This topic is 5960 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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