How do I generate a basic monthly call report?

[PeeBeeEx]

I'm wanting to generate a basic monthly call report which details all calls and costs, etc.

The type of thing you'd typically receive on your monthly phone bill from your service provider.

Nothing too complicated, just something like:

Date Off Call --- Time of Call --- Extension Dialled From --- Number Dialled To --- Duration of call --- Call Type (Mobile, National, 13*) --- Call Cost

I've tried looking online for some answers, came across a couple of 3CX articles (Billing Interface & CDR) but not much else.

From what I gather I need to enable CDR, then I add/sort the fields I want included - but then I don't see the Call Reports section anywhere? (It seems this feature is only for Pro or Ent?)

Is there any way to get some sort of basic report generated using the Standard version? Definitely looking towards Pro in the future, but for the moment just playing around with 3CX at home - even if it doesn't include call costs, mostly just want to have like a record of calls.

Does enabling CDR actually do anything in the Standard version? Even if it just generated the text file with everything, that would kind of suffice. (Albeit not very pretty, but at least the data's there)

The Call Log is awfully similar to the type of things I'd like to achieve - where is this data stored? It seems it keeps track of everything for 90 days? Would it be possible to export the data in the call log in anyway?

Any guidance much appreciated.

 

[cobaltit]

Seems like the information you want is something you would get from your service provider. Are they not providing one or are you trying to fact check their bill? Keep in mind that 3CX has no idea what your calls cost so you'd have to enter all those costs in manually and chances are your provider will bill in increments separate from how 3CX calculates costs. What are you trying to accomplish?

 

[PeeBeeEx]

I'm thinking more towards the future where I hope to have a few 3CX installations in production for customers. In these instances, the SIP providers we'd be using would indeed provide us with call logs and costs, however:

• We wouldn't really want to just forward them the SIP providers call logs, as the pricing would differ slightly and we'd prefer they didn't knowing all the providers we're using under the covers.
• If using a few different trunks with a single environment, would be nice to have everything consolidated. If we were to just forward on our SIP Providers logs, we'd have multiple logs for each trunk/account.
• It wouldn't look too professional just forwarding on other supplier logs; ideally we'd prefer to be able to send our own with our own format/logo or even just the 3CX logo / no logo at all.
• Would be nice to have something automated each month, forwarding on the SIP provider logs would likely require someone manually extracting them from our monthly invoice and then re-emailing.
• Cross-checking / fact checking as you've mentioned would also be a potentially useful bi-product of this.
• It's just the norm for your telephone provider to give you this each month so you can see your bill.

It would just be nice having something somewhat automated that collated all the call logs from multiple SIP Trunks into a single format we'd like; ideally with call costs included.

 

[Cjay]

You could try something like this which I created for my own purposes. It is based around collection/analysis of CDR's.