Finance Ideas

Share your Finance ideas here

New Idea
0 Kudos
dmdaniel Savvy Scholar

Savvy Scholar

It would be great if you could support the payment amount in the return from the REST get account summary, ie /accounts/{account-key}/summary

 

At the moment the payment section response ( below) has no payment amount, which make it hard to display the payment details as its an important detail of a payment.

 

You could add up the paidInvoices.appliedPaymentAmount fields, however that doesn't work if a payment is applied to the credit balance.

 

 

 

{
    "payments": [{
        "paymentNumber": "P-00000075",
        "status": "Processed",
        "effectiveDate": "2013-03-27",
        "id": "2c92c8f83dabf9cf013daf3bfa0305a6",
        "paymentType": "Electronic"
    }, {
        "paidInvoices": [{
            "invoiceNumber": "INV00000159",
            "appliedPaymentAmount": 5,
            "invoiceId": "2c92a09539190dbe0139190f42780012"
        }],
        "paymentNumber": "P-00000056",
        "status": "Processed",
        "effectiveDate": "2012-08-11",
        "id": "2c92a0f9391832b101391922ad5f049d",
        "paymentType": "Electronic"
    }],
  }

 

 

0 Kudos
jbrown Scholar

Scholar

When we sync products and charges to Netsuite, there is a field in Netsuite (Display Name) that does not exist in Zuora.  If you change that product's name, it changes all of the related names in Netsuite EXCEPT for the Display Name.  So all of the charge related fields show one name and the display name shows another.  That field should be supported by the integration.  There should be a "Netsuite Display Name" custom field that we can change when we change the charge names.

0 Kudos
kurtlu Newly Enrolled

Newly Enrolled

Customers are interested in syncing reason codes and additional standard or custom fields to Z-Suite, specifically payment, refund, and IIA transactions.  Suggest making Z-Suite extensible to include additional fields for the customer to sync.

vchakk0th Newly Enrolled

Newly Enrolled

Hi,

 

We need to run the Trial Balance Report in Zuora every Tuesday at 5:30am AEST. Since we perform the activities out of India, we have to log in early just to run this report. Also, it takes a long time to generate the report when we initiate it from India (refer ticket (#87843) & (#87945)).

 

Hence the request is to have an enhancement to be able to auto schedule this report at a specified time at a specified frequency.

 

Please help us by adding this feature to the Zuora interface.

 

Thank you,

Venu

Zuora-Support Community Manager

Community Manager

Extend AR Aging Datasource to include additional account and invoice fields

Status: Coming Soon
by Community Manager on ‎01-13-2016 11:26 AM - last edited on ‎01-17-2016 10:09 AM by Community Manager

Feature Request: Make additional Account and Invoice fields available on the AR Aging Datasource

Reference Number: DE7928

Business Need:

1. Provides additional reporting information regarding account and invoice data

2. Current design requires that two reports be run then combined to pull relevant account data (such as credit balance)

3. Multiple reports required to create a detailed AR aging at the invoice level

Status: Coming Soon
Zuora-Support Community Manager

Community Manager

1 Summary of the enhancement?

Allow rate calculation for volume based rate plans to be based on the aggregate of the quantities of all child accounts.

2. What is the business problem?

We use volume based recurring pricing models.
Our enterprise customers want to aggregate the total quantity subscribed to across the enterprise in order to calculate the appropriate volume pricing level, but have separate charges for each department.
e.g. if we have volume pricing levels for up to 100 widgets at $10 per widget;
100 to 200 widgets at $7 per widget for all widgets.

If company has department A with 50 widgets, department B with 90 widgets, they want to receive an invoice with all quantities priced at $7 per widget (which would be the recurring price if departments A and B's volume was combined), but separate line items for department A ($7 x 50) and department B ($7 x 90).

What is the business impact?

Without this ability, we have to bill such clients outside of Zuora.  Which leads to manual work on our side, and of course removes our biggest customers from being billed through Zuora, which impacts the use of the Zuora reports, etc (and of course reduces Zuora's revenue based on our billing)

What is the proposed solution?

For child accounts, when defining a subscription, allow the selection of a subscription from the parent account.  Quantity is reported in the child accounts, but the billing quantity is aggregated for all child accounts sharing the same subscription; the appropriate rate calculated; and the apportioned amount applied to the child account subscriptions. (The child account could be an informational invoice, of zero dollar, to avoid double billing.)

 

 

0 Kudos
Zuora-Support Community Manager

Community Manager

Currently, this only is allowed through the REST API.

0 Kudos
willgl New Student

New Student

Need to project revenue schedule item

Status: New Idea
by New Student willgl on ‎03-08-2017 07:56 AM
 

Mar 7, 11:26 PST

Hi Zuora,

Is there a way to do a “fake” invoice in Zuora? I want to see what the next month’s Revenue Schedule Item will be without actually running a bill.

For us, Revenue Schedule Item includes both usage (usage-based) and fixed (monthly subscription) charges.

To be specific:

Currently, we run bills once a month. We charge for the preceding month’s usage and fixed charges. Usage depends on the month’s usage, but theoretically fixed charges (monthly plans) should already be in the system, so I should be able to get a 1-month look ahead. How do I get the 1-month look ahead?

 

I have tried projecting the fixed portion:

Starting with the Rate Plan Charge data source, then prorating for any given month based on the start date and end dates of a given rate plan, then summing them up for a given month.

 

But the method does not work historically, so I don’t trust it looking ahead. The method comes to a number almost double the actual Revenue Schedule Item, historically. And I hadn’t even added usage [to this historical backtest].

 

Any advice? This could be complicated so feel free to reach me individually.

 

Thank you,

 

skennedy Student

Student

Currency Management

Status: Unlikely
by Student skennedy on ‎03-22-2017 11:59 AM

currently when we introduce a new product and rate plans etc.  Product Managemnt just prices it out in USD.  So we have to then look up the current exchange rate to get the EUR, GBP an CAD prices and then we set up the rate plans and charges etc.

 

And then 6 months from now - the sales team is quoting in EUR.  and if you were  to do the conversion back to USD - it wouldn't match the list price in USD.

 

And then again say the purchase isn't made for another month or so, the XE rate is yet again different then what was used when the product was introduced, when it was actually billed.

 

So basically there are 3 conversions going on - when the product is created, whenthe product is quoted, and when the prouct is billed. 

 

It's kind of painful, each month when the exchange rate is updated in the system - to them make all the adjsutments on the products as well. the only way i know is to export the product catalog, adjust the pricing and reimport. 

 

Option A.  when the exchange rates are updated in the system - that it then also updates the pricing on the rate plans.

 

Option B. only have pricing in USD.  and then give the option on the quote or something to convert at the time to other currency - using the most recent conversion rates in the system.  and when then quote is sent to ZBilling - it keeps the same rate, that i was quoted on. 

 

** Our cusotmers want to see quotes in EUR, GBP etc. 

Status: Unlikely

We were informed that the "Download Summary Tab Information" in the Accounting Period will be soon phased out. Is there a way to request that this be retained in our production tenant? We find this to be more concise and useful plus it gives us a clear representation/snapshot of the monthly movements in the Accounting Period. The exported "Journal Entry Item" report/extract has too many details and I don't think the numbers are reconciled with the figures as presented by the "Download Summary Tab Information" in the Accounting Period.

 

Thanks and hope this can be considered.

 

Bes,

Mariel

Zuora-Support Community Manager

Community Manager

Currently the invoice API only allows the transferred to accounting field to be set to Yes, Ignore, Error, or Processing.

We need the limitation to be removed, so that we can also set the field back to No.

Once  this is removed, we will be better able to reprocess records in case of failure.

Jim Tutor

Tutor

Scott Weinberg - Quickbase

Mar 21, 04:57 PDT

Is there a way to run the Revenue Detail report that is provided in the Accounting Period section on a full year basis, or for a selected period, rather than just per month?

Dwilli23 Tutor

Tutor

Currently, Zuora does not provide the option to set up a revenue recognition rule that allows for the use of the model "Monthly Recognition over time" to recognize one-time charges over the life of a subscription.  The only option that enables the proper revenue recognition of one-time charges over the life of a subscription is to use of the "Daily Recognition over time" model.  This model does not allow for a smoothed revenue option.  I have spoken with other Zuora users & all are in agreement that this is a critical option that is missing.  In order to achieve the desired revenue recognition model, we are spending countless hours redistributing revenue each month, negating the purpose of the productivity tool that we had expected from the software.  I strongly urge you to consider updating your "Monthly Recognition over time" to include the option to set the Recognition Term End Date to Subscription End Date.

bolaurent Master

Master

It looks like the only way to examine uploaded forex rates is via API, and by a custom call at that (query does not work).

 

Please let Zuora users examine uploaded forex rates.

Zuora-Support Community Manager

Community Manager

In Europe, VAT is reported into separate GL accounts for each country and sometimes product type.
Zuora is limited to assigning a single accounting code for all VAT.

Ability to assign multiple accounting codes for VAT tax‰Û¡ÌÝÌÏ
Ability to assign accounting codes at Tax Rate level.

Zuora-Support Community Manager

Community Manager

Canceling 'out of term' subscriptions from locked accounting periods

Status: Under Consideration
by Community Manager on ‎01-13-2016 11:26 AM - last edited on ‎01-17-2016 10:10 AM by Community Manager

Feature Request:  ability to cancel 'out of term' subscriptions from locked accounting periods that do not initiate any invoices or impact any financial data.

Reference Number: DE10714

Business Need: cannot manage accounts that should be closed because the subscription cannot be cancelled.

Zuora-Support Community Manager

Community Manager

Support RevRecCode and RevRecTrigger fields in the API RatePlanCharge object

Status: Under Consideration
by Community Manager on ‎01-13-2016 11:26 AM - last edited on ‎01-17-2016 10:17 AM by Community Manager

Feature Request: Rev Rec fields not available in the RatePlanCharge object

Reference Number: DE7633

Business Need:

The RevRecCode and RevRecTrigger fields are not available in the RatePlanCharge object in the API. These fields are available in the ProductRatePlanCharge and the InvoiceItem objects. -- This prevents any changes from being made to the Rev Rec values through the API.

Zuora-Support Community Manager

Community Manager

The finance team of our organization require that the amount generated by the report "Invoice Payments Processed Successfully" less the amount generated by "Refunds Processed Successfully" should always match the Subtotal Invoices of the Trial Balance. I opened a ticket to review that topic but the answer was "PM doesn't find a need to make changes to accounting period summary or account period balances. However, we do have a Product Feedback forum where you can post your feature request"

The thing is Accounts Receivable don't make sense to our business case and we don't want it to be reflected in Trial Balance at least.

 

 

0 Kudos
kurtlu Newly Enrolled

Newly Enrolled

Z-Suite to support Credit Balance Adjustments

Status: New Idea
by Newly Enrolled on ‎09-12-2016 04:52 PM

Can we enhance Z-Suite to support syncing credit balance adjustments to NetSuite?  This is a major gap that customers struggle with and end up deciding not to use credit balances.