Frequently Asked Questions

Financial Summary Dashboard FAQ (New)

Assets & Pool Accounts

Infor, Per Diem


Financial Summary Dashboard FAQ

Where does the data come from?

The data that displays in this dashboard comes directly from Banner.

Top

Is the data real time?

This data is updated once a day around 4:00 AM. The information you are looking at on the dashboard is up to date through the prior day.

Who has access to the data?

Anyone who is currently an employee of Liberty can access the dashboard; however, an employee can only see the transactions that contain FOAPALs that they have query access to in Banner. In other words, just because one can access the dashboard, does not mean that any data will be visible.

Top

What do I do if I am not seeing the organizations or accounts that I should see?

Contact Finance Infrastructure to confirm your Fund/Org access. If access is not accurate, submit a Fund/Org request. Please note that Fund/Org access requires supervisor approval.

Is there a way to save a custom view of the dashboard?

If there is one set of filtering that you find yourself going back to time after time, it will be beneficial for you to set up a custom view. In order to do this, simply select “Remember My Changes” in the upper left of the dashboard, and choose a name for the selection of data that you are viewing. After saving the view and checking “Make it My Default”, you will be able to come back to the dashboard later, and it will apply the filters that you had selected immediately.

Top

Can I recieve an email that shows me my dashboard data automaticall?

You can also subscribe through email, and Tableau will send you a scheduled image of the dashboard. This could be useful for a quick view of one specific selection. In order to do this, simply click the envelope icon in the top right, enter your email address and desired time, and click subscribe.

How do I export this data?

There are a couple of choices when it comes to exporting data from Tableau. If the need arises to show someone the data that you’re viewing in the dashboard, and you don’t want to have to replicate all of the filtering and actions that you have performed in order to share what you’re seeing, simply click the “Download” icon and then select “PDF”. This will allow you to create a pdf file of the data exactly as you see it, so that you can easily email or save it (please do not allow any individuals without the proper Fund/Org access to view these exports).

If you would like to export a certain portion of the data into excel, select the portion of the dashboard that you would like to export, click the download icon, and select “Crosstab”. A dialogue box will appear that alerts you that the crosstab has been created, select download, and open the file from your downloads folder.

Top

Oops, I think I messed up.  What now?

If you have been using filters, actions, or just clicking around and you lose track of what data you are viewing, simply click the “Revert” button at the top of the page.  This will remove all filters and actions, giving you a clean slate.

Are there other pages in the dashboard that I can look at?

Currently, you have access to Organization Revenue & Expenses Account Summary, Organization Revenue & Expenses, and Budget Summary. In the future, there may be additional pages that are specific to the overall division the Financial Summary Dashboard supports.

If you have specific information that you would like to see in addition to your Financial Summary Dashboard, please submit a Report Request through the IT HelpDesk or contact your Analytics & Decision Support team.

Top

Why is my tuition revenue not showing?

The Financial Summary Dashboard is intended to show an “unallocated” look at expenses and revenue.  Therefore, you will see only the direct revenues collected by your area.  All tuition based revenue is reported using an allocation method not currently available in this view. 

How do I know what Fund/Org access I currently have?

You can look to see what your current fund/org access by going to the My Fund/Orgn Access Dashboard. Within this view, you can see each Fund and Organization to which you have viewing access.


Assets & Pool Accounts

What is a pool account?

A pool account is an account that consolidates the funding from separate accounts for NSF checking purposes.  This ensures that requisitions will not go NSF because a purchase was moved to a different account.

Top

What accounts are included in the pool accounts?

There are currently two pool accounts related to asset purchases; 7910 for Non-Capital and Capital Expenditures and 7911 for Non-Capital and Capital Medical Expenditures.

Top

Why is my furniture requisition for $350 NSF when I have $1,050 in the account?

The NSF error could be caused by either pending documents or a negative balance in the pool account 7910.

  • Make sure no pending documents are reserving funds.
  • Verifty pool account balance has enough funding.
    • Either add balances of all pool accounts
      732003 (1,227.57)
      791011 1,050.00
      791012 500.00
      7910 Total 322.43
  • Or query the pool account balance using FGIBAVL in Banner INB

Top

Why are my purchases being coded to Small Equipment and Furnishings (732003) if I requisition using a different account?

Finance will amend the account code on assets that do not meet capitalization criteria. For instance, you may purchase a bookshelf for $350 but Accounting does not need to add that bookshelf to the depreciation schedule so it will be moved to an account that does not tag the asset as a capital purchase.

Top

Why can’t I adjust the account code myself?

The asset account codes route requisitions through any necessary conditional approvals.  When the account is adjusted during the requisition process it will bypass necessary approvals which will result in the requisition being cancelled.

Top

Do I need to transfer funds to 732003 to clear the NSF?

No, it is not necessary to transfer funding to 732003 if it is already budgeted within the pool account.

Top

How do I know where to budget asset purchases?

All purchases should be budgeted in the appropriate asset account (where the requisition will be submitted). Asset purchases that have the potential to be moved by Finance have been grouped into pool accounts. 

Top

Why isn’t the pool account visible in all budget queries?

The Budget Availability Query (FGIBAVL) is the only query that contains the table used by Banner for NSF checking. Since pool accounts are only used during the NSF checking process they are only visible in FGIBAVL.

Top

Why do I need a location code on asset purchases?

The location code identifies where on campus an asset is located and is a required field in the Fixed Asset system used by Accounting to manage capital assets. 

Top


Infor, Per Diem

What is Infor?

Infor is the software program that is used to manage expenses incurred by University employees whether they are on a University P-Card, per diem allowance, an out-of-pocket expense, or a cash advance.

Top

Who has access to Infor?

All University employees, excluding student employees, have an Infor account.  The link is available on myLU.

Employees who do not reconcile their own transactions will need to set up a proxy to reconcile on their behalf.

Top

How do I become a proxy?

The employee will need to set you up as a ‘Creator Proxy’ in Infor. Have the employee login to Infor and click on the ‘Creator Proxy’ tab on their user profile.

  • Application: Expense Report

  • Proxy User ID: Username of reconciler

    Note:  Make sure to check the boxes to ‘Allow creator proxies to submit’.

Top

How do I request per diem for an employee who does not have a P-Card?

Per diem for employees who do not have a P-Card should be requested as a reimbursement after travel has occurred. Proxy as the employee who needs a per diem reimbursement and create a monthly Expense Report. Add the Per Diem Allowance to the Expense Report along with any other out-of-pocket expenses. At the end of the month, after all expenses have been reconciled, submit the Expense Report.

Top

How do I request a per diem check before the employee begins travel?

If per diem and any out-of-pocket travel expenses will exceed $100, the employee may request a cash advance. Proxy as the employee who needs the advance and create an Expense Report with the purpose of ‘Cash Advance Request’. Submit the Expense Report at least 10 business days before the advance is needed.

Reconciliation will also need to be completed after travel has occurred. Proxy as the employee who received a cash advance check and create a monthly Expense Report. Add line items for the per diem allowance and any other out-of-pocket expenses. Attach receipts for all of the out-of-pocket expenses, excluding per diem meals. At the end of the month, after all expenses have been reconciled, submit the Expense Report.

Top

How do I request per diem for an employee who does not work in my department?

The employee will need posting access to the appropriate organization code.  Please submit a Fund/Org Access request form. Employees are required to have attended Finance 100 in order to be granted access to a budget other than their home department.

Top

How do I request per diem for a non-University employee?

Payments to non-employees should be accompanied by a contractual agreement and a Banner Requisition, or Banner Encumbrance if a Short Form Agreement is used. If the proper Banner document was not submitted, a Payment Request will need to be submitted in Infor.

Top

What do I do if the person is not listed as a vendor?

If the vendor has a vendor number in Banner, contact pcard@liberty.edu with the L# for the vendor to be added in Infor.  If the vendor does not have a vendor number in Banner, complete the following steps:

  • Obtain a W9 from the vendor

  • Email to acctspay@liberty.edu

  • Provide a copy of the invoice, website or any detailed information about the vendor to Accounts Payable

Top