Trial Balance

(Balance Sheet > Trial Balance)

The Trial Balance in a listing of the name and balance of each account in the general ledger, showing which accounts have debit balances and which accounts have credit balances.  With the FAST Finance Trial Balance report, you can quickly drill down to view details and summarized finance data. You can display a high level overview or select accounting codes to summarize the Trial Balance. You also have the option to drill down and view document details and line items.

Back: FAST Finance Reports

Balance Sheet – 5 Year Trend

(Balance Sheet > Balance Sheet – 5 Year Trend)

The Five Year Balance Sheet reports the assets, liabilities, and equity at a specific point in time, such as at the fiscal year end, in summary form for this fiscal period and for the same fiscal period during the previous 4 years.

You can display a high level overview of this report or you can select filters to summarize the data by account codes or account types.

Back: FAST Finance Reports

Balance Sheet

(Balance Sheet > Balance Sheet)

Reports the assets, liabilities, and equity at a specific point in time, such as at the fiscal year end. You can display a high level overview of these reports or select filters to summarize them by account codes or account types. Tip: X101 shows the fund balance at the beginning of each fiscal year, not to confuse with the current fund balance.

Back: FAST Finance Reports

Invoice Query

(Look Up > Invoice Query)

Use the Invoice Query to list transaction details for vendor invoices. You can select specific filter options including, fund, orgn, payee name, payee invoice, invoice number, range of dates, and the dollar value. After you submit your query, you can drill down to view the detailed line items. Some sites will use the term ‘Department ID’ in place of Orgn.

Specific fields are the Chart, Fiscal Year, Vendor ID, Payee Name and the transaction amount.

The specific filters are shown directly above the report.  The report must be filtered by the Fiscal Period From and Fiscal Period To.

Data can be filtered by  by Chart, Index, Fund, Organization (Orgn/Dept ID), Account (Acct), Program (Prog/Project ID), Activity (Actv), Location (Locn), Payee Name, Payee Invoice, Invoice Number, Dollar Value, and the fiscal period as defined by a start date and end date.

Back: FAST Finance Reports

Document Type Query

(Look Up > Document Type Query)

You can use the Document Lookup tool to display accounting information and solve accounting problems (for example, how many times a purchase order is referenced). After the list opens, you can drill down for detailed information about documents and encumbrance line items.

Specific fields are the document number with a link to the supporting documentation, fiscal year, period and date, the description of the transaction, the transaction type and document reference number, the encumbrance ID with a link to the supporting documentation, G/L Codes (or FOAPAL codes), the outstanding amount and the transaction amount.

The specific filter criteria is shown directly above the report. You can search for a specific document number by entering it into the Document filter field.

Back: FAST Finance Reports

TEM – Query by Acct

(TEM Reports > TEM – Query by Acct)

Query by Acct was designed as a financial tool for budget authorities to look at the activity on their FOPALs by entering your funding string you can tailor the report to the time range you wish.

Once you have run the report you can drill down on TRs and TAs just as if you had searched them in the TEM – Query report.

The right side of the report shows the name of the user that entered the information (this can be the traveler or the delegate depending on who started the TA/TR) and the amount.

Back: FAST Finance Reports

TEM – Query

(TEM Reports > TEM – Query)

The query report was designed for a user who already has a question in mind, need to know what travel Employee X has done? Or I need to follow up on the expenses I just approved? Or can I see if any of my specified employees have submitted any travel requests in the last month?

Once you run the report you will have additional options as drill downs.

You will notice that some TAs don’t have TRs, this is because travelers have not filled for reimbursement for these TAs.

Clicking the report name will drill down to the Itinerary level.  The row with both the TA number and TR number represents the TR’s Itinerary while the row with just the TA represents the TA’s Itinerary.

Clicking on the TA number will give you a breakdown of the expenses with date and description. Selecting the Estimated Pay Amount for any expense item will give you the breakdown by FOPAL. If there is no funding string available then it is a non‐reimbursable expense.

Back: FAST Finance Reports