Standard Financial Reports

Follow

Comments

13 comments

  • Jeanae Remala

    When I try to run the standard "Profit and Loss Versus Budget" report noted above, when I click on the "Run" button, the system blanks out the ledger field and gives me an error message that says "Error - Attempt to de-reference a null object".  What does this mean?  What needs to be done to fix it?  

    0
    Comment actions Permalink
  • Tony

    Hi Jaennae,

    We need you to submit a support ticket to resolve this.

    Thanks,

    Tony

    0
    Comment actions Permalink
  • Sara Sutch

    Is there a way to exlude inactive GL accounts from the financial reports?

    0
    Comment actions Permalink
  • Ryan Faulkingham

    Hi Sara,

    The best way to do this is to create a custom report and selecting only your active GL accounts. Here is a helpful article to walk you through this process. There is also a related ASU course at the bottom of this article: 

    https://support.accountingseed.com/hc/en-us/articles/217569927-Custom-Financial-Reports-Overview

    Thank you,

    Ryan 

    0
    Comment actions Permalink
  • Rebecca Ralls

    I have a couple questions re: the Cash Flow report:

    is there any mechanism in place (Like a "Cash" checkbox on the GL Account) to specify which GL Accounts are to be considered "Cash or Like Cash" accounts to help with validation rules to make sure the Cash Flow category fields are populated in the correct instances ... Particularly Journal Entries. Or does the system use anything flagged as a "bank" account?  

    If the system uses GL Accounts flagged as bank accounts - what are the implications for people who have flagged an account as a bank account in order to be able to reconcile it or use it as the credit side of a cash disbursemet, for example.  i.e. what happens if you populate a cash flow category on a non-cash transcation?

    Thanks!!

    0
    Comment actions Permalink
  • Ryan Faulkingham

    Hi Rebecca,

    Correct, any GL account that has the Bank checkbox checked will flow through to the cash flow report. 

    Typically, the credit side of a cash disbursement will be a bank account that has the bank checkbox checked and this will flow to the cash flow report. 

    If a cash flow category is selected for a GL account that is not marked with the bank checkbox, then this will not flow to the cash flow report. 

    Thank you,

    Ryan

    0
    Comment actions Permalink
  • Rebecca Ralls

    Thanks Ryan, that helps clarify. 

    Does the package have validation rules in place (when cash flow tracking is enabled) to ensure that cash flow categories are assigned when a bank account is specified? Or is it up to the end user to put those in place?

    0
    Comment actions Permalink
  • Ryan Faulkingham

    Yes, once the cash flow is enabled in accounting settings, it is a required field on a cash receipt, cash disbursement, and journal entry line for a GL account that has the bank checkbox checked. 

    Thank you,

    Ryan

    0
    Comment actions Permalink
  • Sophie Kunze

    When you drill down into the underlying transactions from a Financial Report, can we change what fields appear from the transaction? 

    1
    Comment actions Permalink
  • Ryan Faulkingham

    Hi Sophie,

    Currently, these cannot be changed, but we are looking into allowing that. What fields are you looking to add? You should be able to create an underlying report by clicking into the "reports" tab. Here, you will be able to add, group, and filter by fields of your choice. 

    Thank you,

    Ryan

    0
    Comment actions Permalink
  • Jeanae Remala

    I agree with Sophie.  Being able to change the fields to see the "Reference" &/or "Notes" field (our description field on A/P &/or GL Entries, for example) and other fields would be helpful. I do understand custom reports can be created, but that requires several additional steps to obtain the same info we need to do quick reviews of GL accounts for proper posting when trying to close out month-end.  If we could change the fields on the drill-down to see this info, it would save us accountants a lot of time (and Time is Money)!!!  Also, once in the drill-down, if we could change the dates to see the whole year, that would be great too.  These two functions are available in QuickBooks and make things much quicker and easier when reviewing reports.

    0
    Comment actions Permalink
  • Sophie Kunze

    We have a custom field on Transaction that gives some of the same info as "Notes" but also brings in the Payable Line comment (not just the invoice). And removing some of the ones we don't need. 

     

    Do you mean creating a normal Salesforce report to show it? Yeah, we can already do that. We wanted the Transactions from the Financial Report screen though. 

    0
    Comment actions Permalink
  • Ryan Faulkingham

    Hi Sophie and Jeanae,

    Thank you for your feedback and I agree, allowing some customization in the drill down would be very beneficial. I have added this internally to our product enhancement list, but I do not yet have a timeline on when this may happen. Once that becomes available, I will have our customer success rep follow up with the both of you. 

    Thank you,

    Ryan

    0
    Comment actions Permalink

Article is closed for comments.