spacer
WHAT'S NEW } SALES } DOWNLOADS } SUPPORT } LEARN } JOBS JOBS } ABOUT
Home > Support > Newsletters > Billing Newsletter > Page 7


WORKING SMARTER EVERY DAY








 

5 TOP BILLING REPORTS

You can speed your billing process along with a few key reports that take you through every step. Start by reviewing reports that show the big pre-billing picture, then narrow your scope with more detailed reports. Here are the top five to get you started:

You can speed your billing process along with a few key reports that take you through every step. Start by reviewing reports that show the big pre-billing picture, then narrow your scope with more detailed reports. Here are the top five to get you started:

Job Billing Worksheet by AE See a summary for each job’s estimate plus change order amounts, billings to date, open POs, unbilled amounts, and current billing status code. You can also include overbilled jobs and, if you want to distribute them, print one job per page.

Unbilled Costs When you need to review the who, what, where, when, and why of costs, turn to the unbilled costs report.

A/R Proof List After adding A/R invoices, always print an A/R proof list to check your work. You’ll be able to catch any errors before posting and (more importantly) before mailing.

Billing analysis by AE After posting A/R invoices, find out how each AE contributed to this billing cycle. This report will print each invoice and subtotals by client for each AE.

Client vs. Client Gross Margin Printing profitability reports are the quickest way to see which clients are adding the most to your bottom line. While there are many reports to choose from, this report summarizes profitability by client. You can print for a work date range to review profitability by month or job date range to review each job’s overall profitability.

Still looking for that special report? Check the online Clients & Profits Report-o-matic here. It’s an interactive search engine of the 350+ reports you’ll find in Clients & Profits.

By Marty Pennoni

Media billing can be a nightmare—or it can be a breeze. Whether it’s air time or print space, the challenge is the same: get your client’s payment in the bank well before the vendor invoice is due, and accurately account for advance billings.

Lucky you, Clients & Profits makes it really easy.

When you generate a media invoice, C&P recognizes the revenue and automatically makes a media WIP cost entry to the same period. Then, when the media accrual invoice is posted, the media WIP cost is subtracted from the period in which it was posted so costs for the period aren’t overstated. Without this feature, you will either have some large (and incorrect) P&L swings, or you’ll be doing a lot of journal entries at the end of each month.

There is a small set-up piece—checking an accrual box and identifying your media accrual and media cost accounts—but then you’re ready to roll. The up-front work is done when broadcast and insertion orders

 

are added, so media billing is easy. Here are some tips to make media billing even easier:

1) When adding media invoices, use Select/Deselect All if you have a lot of IOs or BOs and want to bill a lot or a few.

2) The earlier (and more) you can bill, the better.

3) Generate invoices on the fly, the day the insertion or broadcast order is generated.

4) Don’t wait until month-end.

5) Never play “bank.” Always have client payments before paying vendors.

Media billing isn’t rocket science, and it doesn’t have to be hard. Just a few small steps in Clients & Profits can turn you into a media billing star!


Marty Pennoni is a Clients & Profits consultant. He can be reached at (517) 896-0781.


} FAQS } NEWSLETTERS } TRAINING } USER GROUP } DATABASE GUIDE } REPORT-O-MATIC } UPDATES } USER GUIDE
     Sign up for Clients & Profits news:  Privacy Policy
     © Clients & Profits, Inc.