Reporting Ideas

Nathan · June 4th, 2003, 08:06 PM

Does anyone have a good method for reporting detailed information on telecommunications costs that they'd be willing to share? I need to come up with a way of listing such costs as 800 service, international service, cellular service, frame relay, ISP costs, calling cards, etc., etc.

Before I pull up Excel and start from scratch, I thought I'd see how you all take care of these things.

Thanks in advance for any and all assistance you can provide.

booman · June 20th, 2003, 02:15 PM

There are companies out there that will charge you money to track all your telecom expenses, and "find" savings.

What we do is track all invoices in an Excel Spreadsheet (sorry!), with account numbers, invoice numbers & dates, payment info, and descriptions. When I review invoices, I look at this spreadsheet and make sure there aren't any discrepancies. (You could also use Quicken, if you wanted a nice GUI).

I also worked with my Telecom vendors to develop rate sheets that I could use if I needed to quote someone a cost. For example, I have a sheet that breaks down our POST-discounted rates for every possible size of PVCs that I could order. I know that installation will cost $xx and will take xxx days.

Sorry to point you back towards Excel, but it is pretty useful. Check out Quicken also. You could set up each account number as a Payee, then set up Categories like "Long Ditsance", "Calling Cards", etc. Your reporting would look great, and with their QuickEntry option, entering new charges would be easy.

mtfs · June 24th, 2003, 09:51 PM

Get a CLEC to come in and show you where you can save money.  They will go over all your services for you in a nice book type report.  You don't have to sign up with them, but who knows they may show you some big savings.

dlgouse · July 16th, 2003, 12:47 PM

I've done the spread sheet trick and the hardest jpart was setting it up. We also got invoices on CD for AT&T and used their provided software to segregate costs. We are currently using the MSS group to validate all our bills. Suppose to save us 20 to 30 %.

smithermang · July 17th, 2003, 07:38 AM

You can use companies like TelCorp who will show you what you are spending and find you better rates. They get a part of the savings you have from the cheaper rates.

June 4th, 2003, 08:06 PM	#1 (permalink)
Nathan Join Date: May 2003 Posts: 4	Reporting Ideas Does anyone have a good method for reporting detailed information on telecommunications costs that they'd be willing to share? I need to come up with a way of listing such costs as 800 service, international service, cellular service, frame relay, ISP costs, calling cards, etc., etc. Before I pull up Excel and start from scratch, I thought I'd see how you all take care of these things. Thanks in advance for any and all assistance you can provide.

June 24th, 2003, 09:51 PM	#3 (permalink)
mtfs PBXtech GOLD 100+ posts Join Date: Jun 2003 Posts: 132	Just call a CLEC to go over it all for you. Get a CLEC to come in and show you where you can save money.  They will go over all your services for you in a nice book type report.  You don't have to sign up with them, but who knows they may show you some big savings.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
CCC Reporting will not load aspx pages	jpkage	IP Office	4	November 6th, 2005 09:06 AM
CCC Reporting error	ajshaikh	IP Office	1	September 19th, 2005 01:40 PM
Unable to run CCC reporting	rkurup	IP Office	2	June 23rd, 2005 10:49 AM
CCC _ PC Wall Board & Reporting problem	deltaserver	IP Office	1	May 20th, 2005 02:46 PM
Paging ideas?	mrgold	Definity Servers	12	September 2nd, 2003 09:28 PM

June 20th, 2003, 02:15 PM	#2 (permalink)
booman Join Date: Jun 2003 Posts: 6	There are companies out there that will charge you money to track all your telecom expenses, and "find" savings. What we do is track all invoices in an Excel Spreadsheet (sorry!), with account numbers, invoice numbers & dates, payment info, and descriptions. When I review invoices, I look at this spreadsheet and make sure there aren't any discrepancies. (You could also use Quicken, if you wanted a nice GUI). I also worked with my Telecom vendors to develop rate sheets that I could use if I needed to quote someone a cost. For example, I have a sheet that breaks down our POST-discounted rates for every possible size of PVCs that I could order. I know that installation will cost $xx and will take xxx days. Sorry to point you back towards Excel, but it is pretty useful. Check out Quicken also. You could set up each account number as a Payee, then set up Categories like "Long Ditsance", "Calling Cards", etc. Your reporting would look great, and with their QuickEntry option, entering new charges would be easy.

Remove advertisements Sponsored links
PBXtech.info Advertisement

July 16th, 2003, 12:47 PM	#4 (permalink)
dlgouse PBXtech SILVER 25+ posts Join Date: Jul 2003 Posts: 52	I've done the spread sheet trick and the hardest jpart was setting it up. We also got invoices on CD for AT&T and used their provided software to segregate costs. We are currently using the MSS group to validate all our bills. Suppose to save us 20 to 30 %.

July 17th, 2003, 07:38 AM	#5 (permalink)
smithermang PBXtech GOLD 100+ posts Join Date: Jun 2003 Posts: 150	You can use companies like TelCorp who will show you what you are spending and find you better rates. They get a part of the savings you have from the cheaper rates.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)