Docstoc

Blank Invoice Templates Event 1 Office Connector Batch Analyzer Page

Document Sample
Blank Invoice Templates Event 1 Office Connector Batch Analyzer Page Powered By Docstoc
					Event 1 Office Connector                    Batch Analyzer                                   Page 1 of 9
bf6e620d-2096-4c15-8301-a6e35f3dcfcb1
                                   General Ledger - Batch Summary                        Date: 7/17/2010
                                                                                          Time: 7:10 PM
Batch Analyzer - Batch Summary
   #NAME?
   #NAME?


This worksheet can be used to assist with analyzing transaction batches. This sheet provides
a summary of GL transaction batches for the desired application of origin and date range.
After selecting the application (optional) and the desired date range, click the Refresh Data
toolbar button above or click the Refresh button for the current and history files below. The
Refresh Data toolbar button may require more time to complete because all other queries in
this workbook will also be refreshed.

Application:                                  Enter the two character application of
Accounting Date:                              origin (or blank for all).
                   From: 1/1/1980             Enter the desired range of accounting
                     To: 12/31/2050           dates.

GLT - Current
Application
Of Origin     Batch                   Debit               Credit                Total
                                                                   $             -
                                                                   $             -
      SUBTOTALS           $            -      $             -      $             -



GLT - History
Application
Of Origin     Batch                   Debit               Credit                Total
                                                                   $             -
                                                                   $             -
      SUBTOTALS           $            -      $             -      $             -




    GRAND TOTALS          $            -      $             -      $             -
Event 1 Office Connector                                                                                                                         Batch Analyzer                                                                                Page 2 of 9
bf6e620d-2096-4c15-8301-a6e35f3dcfcb1                                                                                                             Batch Details                                                                            Date: 7/17/2010
                                                                                                                                                                                                                                            Time: 7:10 PM


Batch Analyzer - Batch Details
    #NAME?
     #NAME?


Use this worksheet to view the batch details for any GL batch. The batch summary provides summary totals from the same batch in any subsidiary ledgers. Below the batch summary section you will
find the detail listing of GL transactions for both the current and history file.


Specify Batch
          Application Of Origin:                                                        <- Enter Application Of Origin
                         Batch:                                                         <- Enter Batch

Batch Summary                                                                                                                  Debit           Credit                     Total
NOTE -                                                                                  General Ledger              $              -    $             -     $              -
                                     Subsidiary Ledgers (click hyperlink for details)


To update the batch totals,
select the Refresh Data toolbar                                                                                             Amount          Retainage                      Net
button above or go to each                                                              Accounts Payable            $              -    $             -     $              -
worksheet and click the
Refresh button. Refreshing the                                                                                           Subtractions       Additions                      Net
specific worksheets that are                                                            Cash Management             $              -    $             -     $              -
needed will take less time than
refreshing the entire workbook.                                                                                             Revenue                  Cost                 Total
                                                                                        Equipment Cost              $              -    $             -     $              -


                                                                                                                            Amount          Retainage                     Net
                                                                                        Job Cost                    $              -    $             -     $              -


                                                                                                                                                                      Net Pay
                                                                                        Payroll                                                             $              -



                                                                                        Property Management         $              -    $             -     $              -


GL Transaction - Current                                                                Batch not found
Account           Accounting Date Journal                                               Description                        Debit            Credit          Reference 1           Reference 2   Vendor   Invoice   Job   Bank   Check   Employee



                                                                                                  SUBTOTALS         $              -    $             -



GL Transaction - History                                                                Batch not found
Account           Accounting Date Journal                                               Description                        Debit            Credit          Reference 1           Reference 2   Vendor   Invoice   Job   Bank   Check   Employee




                                                                                                  SUBTOTALS         $              -    $             -



                                                                                                BATCH TOTALS        $              -    $             -
Event 1 Office Connector                                                              Batch Analysis                                                                     Page 3 of 9
bf6e620d-2096-4c15-8301-a6e35f3dcfcb1                                                Accounts Payable                                                                Date: 7/17/2010
                                                                                                                                                                      Time: 7:10 PM

Batch Analyzer - Accounts Payable
 #NAME?
  #NAME?


Use this worksheet to view the AP transactions for a specific batch. Enter the batch number on the 'GL Detail' worksheet.


APT - Current           Batch not found
                                                               Accounting                                                 Expense   Payable   Retainage   Workflow
Vendor     Invoice      Vendor Name           Transaction Type Date         Amount         Retainage       Bank   Check   Account   Account   Account     Program



                                                       SUBTOTALS            $         -    $           -



APT - History           Batch not found
                                                               Accounting                                                 Expense   Payable   Retainage   Workflow
Vendor     Invoice      Vendor Name           Transaction Type Date         Amount         Retainage       Bank   Check   Account   Account   Account     Program



                                                        SUBTOALS            $         -    $           -



                                                      BATCH TOTALS          $         -    $           -
Event 1 Office Connector                                                            Batch Analyzer                                                                              Page 4 of 9
bf6e620d-2096-4c15-8301-a6e35f3dcfcb1                                              Cash Management                                                                          Date: 7/17/2010
                                                                                                                                                                             Time: 7:10 PM

Batch Analyzer - Cash Management
  #NAME?
   #NAME?


Use this worksheet to view the CM transactions for a specific batch. Enter the batch number on the 'GL Detail' worksheet.

CMT - Register          Batch not found
                                                                      Accounting                                                                                         Reconciliation
Bank Account   Check   Transaction Type   Description                 Date          Subtraction       Addition       Posted   Debit Account   Credit Account   Journal   Status



                                                        BATCH TOTAL                 $             -   $          -
Event 1 Office Connector                                                                                               Batch Analysis                                                                                                            Page 5 of 9
bf6e620d-2096-4c15-8301-a6e35f3dcfcb1                                                                                  Equipment Cost                                                                                                        Date: 7/17/2010
                                                                                                                                                                                                                                              Time: 7:10 PM



Batch Analyzer - Equipment Cost
  #NAME?
  #NAME?

Use this worksheet to view the EQ transactions for a specific batch. Enter the batch number on the 'GL Detail' worksheet.


EQ Transaction - Current              Batch not found
                                                                                                                                                                                                Period
                            Revenue        Revenue                                                        Accounting   Debit     Credit                            Cost                         End      Check
Equipment ID Description    Code           Amount Cost Code       Cost Amount Reference 1   Reference 2   Date         Account   Account   Journal   Job   Extra   Code   Category   Employee   Date     Seq     Pay ID   Vendor   Invoice



                     SUBTOTALS        $        -              $           -



EQ Transaction - History              Batch not found
                                                                                                                                                                                                Period
                            Revenue        Revenue                                                        Accounting   Debit     Credit                            Cost                         End      Check
Equipment ID Description    Code           Amount Cost Code       Cost Amount Reference 1   Reference 2   Date         Account   Account   Journal   Job   Extra   Code   Category   Employee   Date     Seq     Pay ID   Vendor   Invoice



                     SUBTOTALS        $        -              $           -



                   BATCH TOTALS       $        -              $           -
Event 1 Office Connector                Batch Analysis       Page 6 of 9
bf6e620d-2096-4c15-8301-a6e35f3dcfcb1   Equipment Cost   Date: 7/17/2010
                                                          Time: 7:10 PM
Event 1 Office Connector                                                                                                           Batch Analyzer                                                                                                                                    Page 7 of 9
bf6e620d-2096-4c15-8301-a6e35f3dcfcb1                                                                                                 Job Cost                                                                                                                                   Date: 7/17/2010
                                                                                                                                                                                                                                                                                  Time: 7:10 PM



Batch Analyzer - Job Cost
  #NAME?
   #NAME?


Use this worksheet to view the JC transactions for a specific batch. Enter the batch number on the 'GL Detail' worksheet.


JC Transaction - Current                     Batch not found
                                                                                                                         Debit     Credit                                                                                                        Billing                         Contract
Job         Extra       Cost Code   Category Transaction Type   Category Description      Amount         Retainage       Account   Account   Journal   Vendor   Invoice   Commitment   Employee   Equipment   Reference 1   Reference 2   Draw   Invoice   Customer   Contract   Item



                                                                         SUBTOTALS        $         -    $           -



JC Transaction - History                     Batch not found
                                                                                                                         Debit     Credit                                                                                                        Billing                         Contract
Job         Extra       Cost Code   Category Transaction Type   Category Description      Amount         Retainage       Account   Account   Journal   Vendor   Invoice   Commitment   Employee   Equipment   Reference 1   Reference 2   Draw   Invoice   Customer   Contract   Item




                                                                         SUBTOTALS        $         -    $           -



                                                                        BATCH TOTALS      $         -    $           -
Event 1 Office Connector                                                                          Batch Analyzer                                                                                         Page 8 of 9
bf6e620d-2096-4c15-8301-a6e35f3dcfcb1                                                          Property Management                                                                                   Date: 7/17/2010
                                                                                                                                                                                                      Time: 7:10 PM

Batch Analyzer - Property Management
  #NAME?
  #NAME?

Use this worksheet to view the PM transactions for a specific batch. Enter the batch number on the 'GL Detail' worksheet.


PM Transaction - Current                                   Batch not found
                                                                                          Charge                                                       Accounting   Accrual Debit   Accrual Credit
Property      Unit       Tenant         Lease              Description                    Date         Charge type   Charge Amount       Credit Amount Date         Account         Account



                                                                                 SUBTOTALS                           $        -      $            -


PM Transaction - History                                   Batch not found
                                                                                          Charge                                                       Accounting   Accrual Debit   Accrual Credit
Property      Unit       Tenant         Lease              Description                    Date         Charge type   Charge Amount       Credit Amount Date         Account         Account



                                                                                 SUBTOTALS                           $        -      $            -



                                                                               BATCH TOTALS                          $        -      $            -
Event 1 Office Connector                                                                                                                          Batch Analyzer                                                                                                                Page 9 of 9
bf6e620d-2096-4c15-8301-a6e35f3dcfcb1                                                                                                                 Payroll                                                                                                               Date: 7/17/2010
                                                                                                                                                                                                                                                                             Time: 7:10 PM



Batch Analyzer - Payroll
 #NAME?
  #NAME?


Use this worksheet to view the PR transactions for a specific batch. Enter the batch number on the 'GL Detail' worksheet.

PR Transaction - Current                         Batch not found
            Period End                               Overtime                                          Taxes                         Direct                     Employer                                                                       Check           Accounting
Employee ID Date       Check Seq   Regular Pay            Pay       Other Pay       Gross Pay       Withheld       Deductions       Deposit       Net Pay         Taxes        Fringes       CK21TOT       CK22TOT       CK23TOT       CK31TOT Number   Bank   Date



            SUBTOTALS              $      -      $       -      $        -      $        -      $       -      $         -      $      -      $      -      $       -      $      -      $       -     $       -     $       -     $       -


PR Transaction - History                         Batch not found
            Period End                               Overtime                                          Taxes                         Direct                     Employer                                                                       Check           Accounting
Employee ID Date       Check Seq   Regular Pay            Pay       Other Pay       Gross Pay       Withheld       Deductions       Deposit       Net Pay         Taxes        Fringes       CK21TOT       CK22TOT       CK23TOT       CK31TOT Number   Bank   Date



            SUBTOTALS              $      -      $       -      $        -      $        -      $       -      $         -      $      -      $      -      $       -      $      -      $       -     $       -     $       -     $       -


           BATCH TOTALS            $      -      $       -      $        -      $        -      $       -      $         -      $      -      $      -      $       -      $      -      $       -     $       -     $       -     $       -

				
DOCUMENT INFO
Description: Blank Invoice Templates document sample