Contents[LP1]
1. Chart of Account Setup. 5
1.1 Account (aka Natural Account) 5
1.1.1 View. 5
1.1.2 Add. 7
1.1.3 Change. 9
1.2 Attribute Values. 12
1.2.1 Find an Attribute Value. 13
1.2.2 Add an Attribute Value. 16
1.3 Company. 16
1.3.1 View a Company. 16
1.3.2 Add a Company. 19
1.3.3 Change a Company. 20
1.4 Locations. 20
1.4.1 View a Location. 20
1.4.2 Add a Location. 22
1.4.3 Change a Location value. 23
1.5 Cost Centres. 24
1.5.1 View a Cost Centre. 24
1.5.2 Add a Cost Centre. 26
1.5.3 Change a Cost Centre value. 28
1.6 Projects. 29
1.6.1 View a Project 29
1.6.2 Add a Project 31
1.6.3 Change a Project value. 33
1.7 Work Orders. 34
1.7.1 View a Work Order 34
1.7.2 Add a Work Order 36
1.7.3 Change a Work Order value. 38
1.8 Account Group. 39
1.8.1 View an Account Group. 39
1.8.2 Add an Account Group. 41
1.8.3 Change. 42
1.9 Tax Codes. 42
1.9.1 View a Tax Code. 42
1.9.2 Add. 45
1.9.3 Change. 50
1.10 Currency. 52
1.10.1 View. 52
1.11 Account Rule. 53
1.11.1 View. 53
1.11.2 Add. 58
1.11.3 Change. 63
2. How to Create Journal Entries. 64
2.1 Basic Journal Entry. 64
2.1.1 View a posted Journal Entry. 67
2.2 Attach Documents to a Journal Entry. 69
2.3 Upload a Journal Entry using GL07 template. 70
2.4 Recurring Journal Entries. 74
2.4.1 Set up Accrual Key. 74
2.4.1 Create a Recurring Journal Entry. 78
2.5 Self-Reversing Accrual Journal Entry. 81
2.6 Intercompany Journal Entries. 86
2.7 Journal Entry Templates. 87
2.7.1 Create a Journal Entry Template. 87
2.7.2 Use a Journal Entry Template. 88
2.8 Journal Entry Changes / Corrections. 90
2.8.1 Correct one or more rows of a Journal Entry. 90
2.8.2 Reverse a Journal Entry. 93
3. How to Open a New Period (Not Year-End) 106
4. Update the GL with data from external systems. 110
4.1 Import Financial Accounting Data. 110
4.1.1 Ceridian. 110
4.1.2 Cornerstone. 110
4.1.3 Active Network. 117
4.1.4 D-Hub (Blackbaud Enterprise CRM) 117
4.1.5 Professional Conference Registration System.. 117
4.1.6 Residential Campaign. 117
4.1.7 Shopify. 118
4.1.8 Team Raiser (part of BlackBaud) 118
4.1.9 OMA. 118
4.1.10 US Bank Visa (Corporate Visa Card) 118
4.1.11 Webtime. 118
4.1.12 Bank Statement Upload. 118
4.2 Ontario Monitoring for Health (OMH) Data. 118
4.2.1 Import Cheque Payment Data into Unit 4. 118
4.2.1 Export Cheque Payment Data into OMH. 118
4.3 Corporate Express Data. 118
5. Monthly Processing. 119
5.1 Manage GL Changes in U4BW, Templates, and External Systems. 119
5.2 Manage Parked Transactions. 120
5.3 Update the GL by Importing Data from External Systems. 125
5.4 GL to AP Reconciliation. 126
5.5 GL to AR Reconciliation. 133
5.6 Run Depreciation. 139
5.7 Bank reconciliation. 139
5.8 Transactions in Error 139
5.9 Monthly revaluation for foreign currency transactions. 143
5.10 Grant revenue recognition Triggers. 146
5.11 Month End Allocations. 149
5.12 Soft Close the Period. 150
5.12.1 Close Individual Modules. 153
5.13 Produce Draft Financial Statements. 156
5.14 Record Adjusting Entries. 156
5.15 Perform Hard close of period and Change the current month. 156
5.16 Produce Final Financial Statements. 156
5.17 Open Posting Cycles. 157
5.18 Update Foreign Exchange Rates. 157
6. Year-End Close. 161
6.1 Create a new fiscal year 161
6.2 Year End – Transfer Balances. 164
6.2.1 Transfer Balance Entries – Income Statement setup. 164
6.2.2 Transfer Balance Entries – Balance Sheet setup. 166
6.2.3 Year end Transfer Balance Entries. 168
6.2.4 Transactions in Prior and Current Fiscal Year 178
[LP1]New to add instructions for the items in yellow (mostly interfaces)