Accounting For Nonprofits Bank Reconciliation Guide

3y ago
31 Views
2 Downloads
1.41 MB
118 Pages
Last View : 22d ago
Last Download : 2m ago
Upload by : Eli Jorgenson
Transcription

041902 2002 Blackbaud, Inc. This publication, or any part thereof, may not be reproduced or transmitted in anyform or by any means, electronic, or mechanical, including photocopying, recording, storage in aninformation retrieval system, or otherwise, without the prior written permission of Blackbaud, Inc.The information in this manual has been carefully checked and is believed to be accurate. Blackbaud, Inc.,assumes no responsibility for any inaccuracies, errors, or omissions in this manual. In no event willBlackbaud, Inc., be liable for direct, indirect, special, incidental, or consequential damages resulting fromany defect or omission in this manual, even if advised of the possibility of damages.In the interest of continuing product development, Blackbaud, Inc., reserves the right to make improvementsin this manual and the products it describes at any time, without notice or obligation.The Raiser’s Edge, MatchFinder, ParaGon, RE:Alum, RE:Event, RE:Member, RE:Queue, RE:Tribute,RE:Volunteer, RE:Zip, and Blackbaud are registered trademarks of Blackbaud, Inc.All other products and company names mentioned herein are trademarks of their respective holder.AFN-BankReconciliationGuide-041902

%DQN FFRXQW 5HFRQFLOLDWLRQ *XLGHINTRODUCTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1Documentation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2User’s Guide Format . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3Using Online Help . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4SYSTEM BASICS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5Parts of the Main Screen . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6Buttons . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8Menu Enhancements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10Shortcut Menus and Grids . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .11Standard Utility Screens . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14General Ledger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15Project, Grant, and Endowment Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16Exporting to Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16SETUP WIZARD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19General Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Checks Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Deposits Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Summary Tab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Wizard Finish Line . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2021222325BANK ACCOUNT RECONCILIATION . . . . . . . . . . . . . . . . . . . . . . 27Getting Started . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Reconciling Accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Reconciliation Adjustments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Viewing Details . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Changing Settings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2829343738ADJUSTMENTS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43Adjustments Setup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44

New Adjustments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46UTILITIES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49Posting to General Ledger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50Raiser’s Edge Batches . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54General Ledger Import . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56REPORTS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61Getting Started . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Creating Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .Sample Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .62647784ELECTRONIC FUNDS TRANSFER . . . . . . . . . . . . . . . . . . . . . . . . 91Electronic Funds Transfer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 92Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94ELECTRONIC RECONCILIATION . . . . . . . . . . . . . . . . . . . . . . . . 95Electronic Reconciliation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 96GLOSSARY . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99INDEX. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111

,QWURGXFWLRQIn This ChapterDocumentation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2User’s Guide Format . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .3Chapter Elements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .3Design Elements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .3Using Online Help . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .4

2CHAPTER 1Welcome to Bank Account Reconciliation, an optional module, designed toenhance the Bank Accounts module of your Blackbaud programs. With BankAccount Reconciliation, you can reconcile your bank account, track the accountbalance, and review in-depth details about individual transactions. The moduledisplays all transactions affecting a single bank and lets you view informationfrom The Raiser’s Edge for Windows.You can add Bank Account Reconciliation to these Windows programs: AccountsPayable, Accounts Receivable, Miscellaneous Cash Receipts, Payroll, andStudent Billing; and it works with General Ledger for Windows and TheRaiser’s Edge for Windows.With Bank Account Reconciliation, you can view both deposits and checks fromthe same screen, along with the bank account balance. For example, you can viewa Student Billing deposit, Accounts Payable computer check, MiscellaneousCash Receipts deposit, and The Raiser’s Edge batch total, all from the samescreen.Bank Account Reconciliation does not appear as a module on the program menu.Instead, its functions appear on the menu bar of the Bank Accounts main screen.Under the File, View, and Utilities menus, you can find new options that appearonly with the installation of Bank Account Reconciliation.A Setup Wizard helps you establish a beginning balance for your bank account.You can reconcile manually or electronically, and you can add adjustments, suchas service fees, during reconciliation. These adjustment transactions can then beposted to your General Ledger.Before you begin reconciling an account, you need to perform a setup for eachnew and existing bank account. Bank Account Reconciliation’s Setup Wizardsimplifies this process. You simply enter a beginning balance, a starting date, andthen mark checks and deposits that have cleared the bank. The programdetermines if your account is in balance. If it is not, the program prompts you toadd an adjustment or return to setup and make changes. Once you are set up forreconciliation, you can begin reconciling on a regular schedule or as determinedby your organization’s needs.As a part of the reconciliation process, you can enter adjustments, view the BankAccount register, import transactions into the register, and post adjustmentactivity to General Ledger.Bank Account Reconciliation also offers the capability of reconciling your bankaccount electronically using a Quicken file provided by your bank.DocumentationSince Bank AccountReconciliation workswith Bank Accounts, werecommend you also readthe Bank Accounts chapterin the user’s guide of yourmain Blackbaud program.The documentation for Bank Account Reconciliation consists of this user’s guide,an online user’s guide, and online Help.In addition to this manual, we encourage you to use the online user’s guide. Itconsists of a PDF (Portable Document Format) file, which you can install on yourcomputer during the program installation process.You can view the online user’s guide on your computer screen. You also can printall, a few pages, or even a partial page of the manual. The online user’s guidecontains links. These links let you navigate through the manual easily. With aclick of your mouse, you can jump from the Table of Contents to Reports.

INTRODUCTIONTo view the online manual, use the Adobe Acrobat Reader . The Acrobat Readerinstalls with your Blackbaud programs. If the Acrobat Reader is not installed, youcan install it from your main program installation CD, or you can download it,free of charge, from the Adobe web page at http://www.adobe.com.As part of the online Help, we have added a Notes feature. The text-ready notefiles are added to your Blackbaud folder during installation. Here you can enterand maintain notes about the program in the Help file as you use Bank Accounts.Your notes can contain organization-specific information about how to best usethe program to suit your needs.User’s Guide FormatChapter ElementsEach chapter contains these elements: In This Chapter: A list of chapter contents. Overview: A brief description of the chapter. Procedures: Step-by-step instructions with explanations to complete theprocess. Summary: A review of chapter highlights. Reference: A detailed, field-by-field description of program screens,which appears at the end of most chapters.Design ElementsThe table below explains the design elements this manual uses as visual cues todenote important information.FormatDenotesThe note symbol designates a note or tip related tothe information in the main text column.The clock symbol designates a shortcut ortimesaving action.The stoplight symbol designates a warning or item ofimportance.BoldBold text designates the name of a field or button, forexample, Print.ItalicsText in italics designates the name of a programmodule, for example, Security, or an optionalmodule, for example, Bank Account Reconciliation.Bold ItalicsText in bold italics designates a Blackbaud programname, for example, General Ledger.small capsThis signifies a key on the keyboard. “PressDELETE,” refers to the key on your keyboard.“Click Delete,” refers to an on screen button.3

4CHAPTER 1KEY KEYTwo key names joined by a plus sign means youpress the keys simultaneously to execute thecommand. For example, if you are instructed to“Press CONTROL F” you must press the CONTROLkey and the F key at the same time.KEY, KEYTwo key names separated by a comma means youmust press the keys in the order in which theyappear. For example, if you are instructed to press A,F, you must press the A key, release it, then press theF key.SHIFTThe SHIFT key allows you to select consecutiveitems from a grid. To select consecutive items,highlight the first item, then press and hold SHIFTwhile selecting the second item.CONTROLThe CONTROL key allows you to selectnonconsecutive items from a grid. To selectnonconsecutive items, highlight the first item, thenpress and hold CTRL while selecting the next item.Using Online HelpWhen you add Bank Account Reconciliation to your Accounting for Nonprofitsprogram, the online Help file is also added. The online Help file gives you accessto overview information, reference information, and procedures.If you need resources beyond online Help, you can access the online manual byselecting Online Documentation from the Help menu. This opens a PDF(Portable Document Format) file in Acrobat Reader. You can also access themanual from your installation CD.We also provide files for your user-defined notes, accessed by clicking Notes onthe Help file toolbar. These files (brnotes.doc and brnotes.txt) are located in yourBlackbaud folder. Depending on your word processor, you can use either theMicrosoft Word document or the text file. This gives you a handy place to storeinformation specific to your organization’s needs. The big advantage of the notesfile over the Annotate feature in the Help file is you can maintain one notes filefor everyone in your organization. To share your notes/tips with your coworkers,copy the notes file to the Blackbaud folder on their hard drive.If you do not have Microsoft Word, delete brnotes.doc in the \Blackbaud directoryon your hard drive (or on the drive where your program resides). Once you deletebrnotes.doc, the Notes button can access brnotes.txt using Notepad.You can access online Help in two ways: Select Help from the menu bar, or Press F1 from most screens in Bank Accounts.Selecting Help from the menu bar or pressing F1 displays a menu of Blackbaudprograms installed in your system. You can select Bank Account Reconciliationfrom this menu to access the Contents, Index, and Find tabs in the Help file.

6\VWHP %DVLFVIn This ChapterParts of the Main Screen . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .6Title Bar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .7Menu Bar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .7Toolbar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .8Filters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .8Status Bar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .8Buttons . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .8Toolbar Buttons . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .8Standard Buttons . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .9Menu Enhancements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .10File Menu . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .10View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .10Utilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .10Help . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11Shortcut Menus and Grids . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .11Using Shortcut Menus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11Sorting the Grid . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .12Standard Utility Screens . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .12Print Setup Screen . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .12Calendar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .13Calculator . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .13Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .14Security Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .14General Ledger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .15Project, Grant, and Endowment Management . . . . . . . . . . . . . . . . . . . . . . . .16Exporting to Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .16

6CHAPTER 2This chapter introduces you to the enhancements found in Bank Accounts whenyou add Bank Account Reconciliation. You may be adding Bank AccountReconciliation to your existing Blackbaud programs, or you may have purchasedBank Account Reconciliation as part of your first Blackbaud accounting package.In either case, this chapter defines the screens you see and the Bank AccountReconciliation functions you now have available through Bank Accounts.It is important to remember that this manual is not designed to provide all theinformation needed to use Bank Accounts. Whenever necessary, you should referto the user’s guide for your main Blackbaud accounting program. It containsspecific information about Bank Accounts. If you have multiple Blackbaudaccounting programs, you can refer to each program’s manual since BankAccounts is a shared module.This chapter also provides basic information about navigating in the module anddetails about how to establish access rights to Bank Account Reconciliation in theSecurity section. It explains the differences in the module when you haveBlackbaud’s General Ledger and Project, Grant, and Endowment Managementfor Windows installed.Read through this chapter to gain a better understanding of the module. You canfind additional detailed information and step-by-step procedures in specificchapters.Parts of the Main ScreenUnderstanding the information in this chapter helps you navigate through theprogram, as well as identify Bank Account Reconciliation options. Thisinformation is helpful whether you are a new or longtime user of Blackbaudaccounting software.Your main programcan include any of theWindows versions of thefollowing Blackbaudaccounting programs:Accounts Payable,Accounts Receivable,Miscellaneous CashReceipts, Payroll, orStudent Billing.When you add Bank Account Reconciliation to your existing Blackbaudaccounting package, additional options become available from the register inBank Accounts. While the appearance changes slightly, the familiar functionsremain the same.

SYSTEM BASICSThe main screen includes a title bar, menu bar, toolbar, bank register grid, filters,and status bar. It appears when you access Bank Accounts from your mainprog

When you add Bank Account Reconciliation to your Accounting for Nonprofits program, the online Help file is also added. The online Help file gives you access to overview information, reference information, and procedures. If you need resources beyond online Help, you can access the online manual by selecting Online Documentation from the Help .

Related Documents:

SUBSIDIARY LEDGER RECONCILIATION 3 By following procedures outlined in this guide, you can reconcile subsidiary ledgers in Accounting for Nonprofits 6.4 and The Raiser’s Edge to General Ledger.In version 6.4 of Accounting for Nonprofits, subsidiary ledgers include Accounts Payable, Accounts Receivable, Miscellaneous Cash Receipts, Student Billing, Fixed Assets, and Payroll as well as .

Hence, the Bank Reconciliation Statement will commence with the balance as per closing balance of the Bank Statement. This means that the Bank Reconciliation Statement is a continuation of the Bank Statement. It must be pointed out to learners that entries recorded in the Bank Reconciliation Statement are recorded from the Bank ˇs point of view.

Bruksanvisning för bilstereo . Bruksanvisning for bilstereo . Instrukcja obsługi samochodowego odtwarzacza stereo . Operating Instructions for Car Stereo . 610-104 . SV . Bruksanvisning i original

User Guide - Bank Reconciliation Manager Page 12 of 21 5. Bank Reconciliation This chapter describes how to use Bank Reconciliation Manager to reconcile the bank statement csv files with the transactions in Sage Accpac ERP. Automating the reconciliation process can save you a lot of time, especially, if you have a lot of transactions. (Please .

Northern Bank & Trust Co. Patriot Community Bank People's United Bank Pilgrim Bank Radius Bank RTN Federal Credit Union Santander StonehamBank TD Bank The Cooperative Bank The Savings Bank The Village Bank Walpole Cooperative Bank Wellesley Bank Winchester Co-operative Bank Abington Bank Bank of Canton Blue Hills Bank Boston Private Bank & Trust

files directly into the system to expedite the reconciliation process. Bank Reconciliation Interaction The following diagram illustrates the interaction between Bank Reconciliation and various modules. More information on module interaction can be found in "Concepts: How This Module Works" on page 3. Figure 1: Bank Reconciliation interaction

The Bank Reconciliation window will close, and a new entry will appear in the . Bank Reconciliations grid. If you would like to view the Bank Reconciliation report (the list of items cleared on this reconciliation), click Yes. Note You can Undothe reconciliation if a mistake has been made.

the methods described in ASTM-C181 [4] and ISO 1927-3 [5]. From these results, the WI (based on the four first rams, calculated in Eq. (1) ), the extended WI (based on all 100 rams, calcu- lated in Eq. (2)) and changes in height and changes in density per ram as reported by the auto- mated sand-rammer. The density calculation is based on the .