Reporting & Analytics

[dogichow]

Script that returns daily breakdown of transaction (like any accounting software), and can do this between two arbitrary dates e.g.:

5/3/2013 Openning balance: $4000 Transactions: 14 Transaction volume: $600 Funds added: $0 Closing balance: $3400

5/4/2013 Openning balance: $3400 Transactions: 10 Transaction volume: $450 Funds added: $0 Closing balance: $2950

5/5/2013 Openning balance: $3400 Transactions: 10 Transaction volume: $400 Funds added: $1500

Discussed it with @mahmoudimus. Could be a nice add to the new dashboard.

[mjallday]

I agree, we've mocked out some concepts for analytics before (see below) but it would be good to spec out exactly what's required before we implement.

@dogichow it sounds like you're more interested in getting raw CSV data than visualisations?

[dogichow]

CSV is fine as a download format, if the fields that I outlined are in and I can specify to-from date ranges. Hate to admit it (because their UI is terrible) but the way QuickBooks does it could be a good point to start from (drop downs, date ranges, etc.).

The viz is nice, but I am not sure what I would use it for. (Also stacked graphs are not that helpful from a glancability standpoint. At least I would add a toggle between stacked and line).

[dmdj03]

CSV download - moved to this issue: https://github.com/balanced/balanced-dashboard/issues/11

[dmdj03]

Here are some analytics requested by customers:

• # of credit card declines • # of return/active customers • Top performing customers • Revenue growth • # of customers • # of debits per given period • # of credits per given period • Marketplace fees collected

[dogichow]

Any updates on this issue? We really need it for accounting.

[mjallday]

@dogichow csv exports are almost done via #11 but we haven't started on aggregated analytical information. it will come after the basic functionality for the new dashboard is built out.

[dogichow]

Hey guys any updates on this feature? I see you rolled out the new dashboard, but AFAIS it does not have any of the metrics that we discussed there. Is there are estimate when you guys will get to this?

Also congrats on the new dashboard! It looks way cooler than before ^_^

[mjallday]

@dogichow we're still working on the migration from our existing dashboard. We need to complete the beyond parity milestone before we can move on to developing any new features.

[dantmurphy]

@dogichow we might be able to assist.

We're building an in-app accounting API (best described as 'Mixpanel for CFOs').

Can you ping me a link to your app, so I can understand your business model. Please let me know specifically what accounting reports your want (if different from what you've mentioned above)?

We are working on providing customer level real-time financial reporting (e.g. profitability per customer) and more traditional financial reports (balance sheet etc.)

Hopefully I can get you set up in no time ;-)

[dogichow]

@dantmurphy Thanks for reaching out! Unfortunately I cannot link to our app, since it's an internal app. I really only need the basics on the global account level (at any given they where we are for example). Right now at the end of the month I have to backtrack and count by hand (!) if I want to know our balance on a given day in the past.

Per costumer level analytics is most def super interesting, but not vital for us. If you could get me started with the line items I included in the beginning of this issue that would much appreciated. :hamster:

[dantmurphy]

@dogichow sure thing, I can help out with these reports.

Here are the HTTP calls (http://goo.gl/XkZ9EG) required for a fictional company called RideSharingCo (similar business model to Uber, Lyft etc). side note: we also have a ruby gem.

Let me know what you think, if you're interested I can put together the API calls for your app and get you set up asap.

No more data entry - YAY!

;-)

[jkwade]

from a customer:

I suspect some sort of nominal " at a Glance" page where the is a dropdown for "The year" "the month" "the week" or "the day" that showed a few numbers like total $ debited, total $ credited, etc would probably make a lot of pointed haired bosses happy :)

[dmdj03]

Modified some of the styles:

[dmacquart]

The CSV export function currently pulls all historical transaction data by default, which can lead to massive files and confusion (e.g. I requested total credit for May only - numbers don't make sense). I should be able to select date range, type of transaction (say "debits") and get only that info.

[mjallday]

@dmdj03 in this mock, is this related to cards used in txns, or cards tokenized on the marketplace?

[dmdj03]

This is for cards used in txns only.

[dmdj03]

To provide a higher level summary of your marketplace performance, we'll have an overview page of key performance indicators to provide a snapshot the health of your marketplace. The page also includes a "to-do list" of items needing attention, but not to the level of urgency reserved for the notification header bar. Clicking on a performance metric will take you to the relevant graph in the analytics section.

Clicking on "see list" from the disputes section of the "to-do list" takes you to a filtered list of new disputes requiring documentation submission:

[msherry]

What's the status on this?