I have updated the Unpaid Invoices Report found in Billings under the Client heading. It now totals the unpaid amounts and displays the total at the very bottom of the report. Download it from the link below, unarchive it, and put it in your Billings template folder.

Click here to download!!!

Thanks

Oscar,

Thanks for this report. I know I'm being picky but would it be possible to add the "$" back to the individual client totals. As well as keep the decimals (cents) when they are .00

Mark et al,

Here's a version with $0.00 and a little bit of finessing with the fonts and layout (my apologies, but my house style is based on Gill Sans).

Look in your User/Library/Application Support/Billings/Templates folder, make a duplicate of this template, double click it and then double click inside the boxes to play with the formatting. Make a mess. Seems it's the only way to learn.

Download my version.

This message has been edited. Last edited by: Matt Davis,

Matt, your link isn't working.

quote:

Originally posted by Mark Des Cotes:
Matt, your link isn't working.

Does now. Just getting used to the way this forum works.

Works for me now. Don't expect anything magical, but hopefully it will bring a sigh of relief to someone.

Thank You Matt,

Your unpaidInvoiceTotal.bitemplate is right for me. I just remove the MDMA in the name and put it in the templates folder.

Question 1 to Oscar; Can we rename files in the templates folder ?

Question 2 to Oscar; Despite having one copy of each .bitemplate files in the templates folder, all of them are show twice in left column of the Report windows.

I took your report (thank you!) and prettied it up a bit to look more like the rest of the reports. In case anyone's interested, here it it.

Here's my version

Any chance of a version that would allow one to filter the report by client and/or by project?

I'd love to have a way to send a "past due" sort of report to clients, and this would do the trick if I could do that sort of filtering.

These templates broke when I upgraded to Billings 3. Would not convert.

I can't figure out why outstanding totals were not included in Billings 3 reports.

Yep, I'd also like to see a solution to this. Billings2 template is broken...

Hi,

I've done the little work!

Enjoy it in the Thread:

Unpaid Invoices Total

Best,
Bernd

Bernd-

Not quite sure what you mean here.... did you fix the downloads above in the thread so they work with Billings3? I tried downloading and putting in that templates folder, but I don't see it in the reports when I bring them up in Billings3... thanks!

Here is it only a pointer to the right location in

Marketcircle > Forums > Billings > Share Zone
.

So, and for uploading it I "zipped" the file. Please unzip the file and put it then into your template folder.

Best,
Bernd

quote:

Originally posted by pdadoc:
Bernd-

Not quite sure what you mean here.... did you fix the downloads above in the thread so they work with Billings3? I tried downloading and putting in that templates folder, but I don't see it in the reports when I bring them up in Billings3... thanks!

Thanks- I had missed the new location. Quick question.... any idea why an invoice I just sent yesterday does *not* show up in the total? This is *not* an issue with your template. I note that in the original Unpaid Invoices report, I also see for this client the amount due in red, but just above that, the total in black is $0. Perhaps a bug?

Don't know! I suggest to send the problem with YOUR data to Billings support. Maybe this is a bug or You have made a little mistake

Best,
Bernd

quote:

Originally posted by pdadoc:
Thanks- I had missed the new location. Quick question.... any idea why an invoice I just sent yesterday does *not* show up in the total? This is *not* an issue with your template. I note that in the original Unpaid Invoices report, I also see for this client the amount due in red, but just above that, the total in black is $0. Perhaps a bug?