Bank Reconciliation Processing

2y ago
60 Views
2 Downloads
2.55 MB
61 Pages
Last View : 16d ago
Last Download : 2m ago
Upload by : Kaydence Vann
Transcription

Bank ReconciliationProcessingSYSTEM ADMINISTRATIONAND PROCESSING GUIDELast revised: 8/19/10 12:22 PM

New World Systems1BANK RECONCILIATION PROCESSINGCONTENTSContents .1Introduction .3System Administrator Guide .4Company FM Settings .4Security Set-Up .4User Security . 4User Based Security/Sub Ledgers Function . 13User Based Security/Sub Ledger General Tab . 14User Based Security/Sub Ledger GL Organizations Tab . 14Bank Reconciliation Processing Pre-work . 16Payment Reconciliation Batches . 16Receipt Deposit Batches . 19Collection . 20Returned Checks. 27Receipt . 28No Receipt . 29Permit Payment . 30Bank Account Journals . 31Revenue and Expense Adjustments . 32Wire Transfer In and Out Adjustments . 34Reconcile Bank Accounts . 39Payment Reconciliation (- Cash Balance. 40Deposits ( Cash Balance ). 43Returned Checks (- Cash Balance). 45Wire Transfer In ( Cash Balance) . 45Wire Transfer Out (- Cash Balance) . 46Adjustments ( or – Cash Balance) . 47Attaching Documents . 48Remote Documents . 50Adding Notes . 50Bank Reconciliation Reports . 52Payment Register . 52Bank Account Reconciliation Report . 54Bank Reconciliation Inquiries. Error! Bookmark not defined.Appendix A . 58Deposit Batches with Credit Card Payments . 58Bank Reconciliation ProcessingFile: Bank Reconciliation Processing.docnewworldsystems.comLast Saved: 5/25/18 8:52 AM

New World Systems2BANK RECONCILIATION PROCESSINGBank Reconciliation ProcessingFile: Bank Reconciliation Processing.docnewworldsystems.comLast Saved: 5/25/18 8:52 AM

New World Systems3BANK RECONCILIATION PROCESSINGINTRODUCTIONWelcome to the Logos.NET Bank Reconciliation Processing guide. Thismanual will guide you through both the setup and processing aspects ofBank Reconciliation Processing.The guide is divided into two sections.The System Administration Guide will focus on the set-up componentsnecessary to utilize Bank Reconciliation Processing within Logos.NET. Thiswill include detailed information on master files that must be set-up such asBudget Levels and Budget Methods and will also include the securitysettings which will be utilized to enable workflow and tailor user options toyour needs.The End User Processing Guide will describe the steps, workflow andoptions available in Bank Reconciliation Processing to the end-user. It willguide you through the process from receipt deposits, through reconcilingpayments and bank adjustments. Included in the section will be a guide tothe standard reports available in the software.This document is available in Microsoft Word format to allow forcustomization to your organization’s particular needs and procedures.Bank Reconciliation ProcessingFile: Bank Reconciliation Processing.docnewworldsystems.comLast Saved: 5/25/18 8:52 AM

New World Systems4BANK RECONCILIATION PROCESSINGSYSTEM ADMINISTRATOR GUIDECompany FM SettingsOn the Payment Reconciliation Method Field, always set the value to BankReconciliation- Daily Reconciiation.Maintenance Financial Management Company FM Settings . Then select the BankReconciliation tab.For the ACH Clearinghouse Bank field, only choose an option here if you areplanning to create export files created for Wire out transfers that will beuploaded to your bank.Security SetupSecurity for the Bank Reconciliation Processing is controlled throughApplication Permissions, Process Manager, and User Based Security.In simple terms, users will have access to process Bank ReconciliationAdjustment Journals, Reconcile Checks, Process Deposits, and Process aBank Reconciliation for the month depending on their job function andduties. These permissions can also be separately parsed out by job functionif needed.User SecuritySecurity templates can be created to assign User Permissions to individualswho will be processing Bank Reconciliation tasks.Bank Reconciliation ProcessingFile: Bank Reconciliation Processing.docnewworldsystems.comLast Saved: 5/25/18 8:52 AM

New World Systems5BANK RECONCILIATION PROCESSINGMaintenance Logos Suite Security Security TemplatesTo create a new template, click the New button and create a namingconvention. Starting off with FM is common to differentiate betweenFinance and other modules.Once created, highlight the template name in the list and click thepermissions button. This will open the Permission Records screen whereeach line represents a screen or button that a user can be given access to.The feature group drop-down allows permissions to be sorted by function.All Bank Reconciliation permissions are included in the FM-BankReconciliation feature group except for Payment Reconciliation permissions.Bank Reconciliation ProcessingFile: Bank Reconciliation Processing.docnewworldsystems.comLast Saved: 5/25/18 8:52 AM

New World Systems6BANK RECONCILIATION PROCESSINGPayment Reconciliation permissions are located under the PaymentProcessing Feature Group.Click on the red X twice to change it to a green checkmark, which allowsaccess to these permissions. The permissions can be combined under oneFM-Bank Rec template, or, if different individuals have separate functionswithin the municipality, they can be separated and given to individual users.Once these templates have been created, they must be assigned to theusers who will be utilizing them.Maintenance Logos Suite Security UsersClick on the Permissions button, then the Inherit button and a list ofavailable templates will appear. To assign the template to the user, movethe chosen template to the right hand side of the Assigned Templates box.Permission Type – Company ApplicationsFeature Group – Bank Reconciliation xxxxPrintFile: Bank Reconciliation Processing.docxView/UseBank Reconciliation ProcessingxDeleteBank Account JournalEdit/Post ListingChangeFMDescriptionAddFMComponentBank Account ActivityReportBank Account inquiryAllAppFMxnewworldsystems.comLast Saved: 5/25/18 8:52 AM

New World Systems7BANK RECONCILIATION PROCESSINGFMFMFMFMFMFMFMFMFMFMFMFMFMBank Reconciliation ProcessingFile: Bank Reconciliation criptionAddFMComponentBank Account Journal ErrorListingBank Account Journal FundSummaryBank Account JournalProcess ManagerBank Account JournalProcess Manager- CreateACH Transmittal FileBank Account JournalProcess Manager- ExecuteAll ProcessesBank Account JournalProcess Manager- PostBank Account JournalProcess Manager- Print Edit& Error ListingBank Account JournalProcess Manager- ValidateBank Account JournalProcessingBank Account JournalTransaction ListingBank AccountReconciliation ReportBank ReconciliationImport- Transmittal AuditListingBank ReconciliationImport- Transmittal EditListingDisplay Bank AccountTransactionDisplay returned CheckTransactionReceipt Deposit BatchEdit/Post ListingReceipt Deposit Batch ErrorListingReceipt Deposit Batch G/LDistribution SummaryReceipt Deposit BatchProcess Manager- ExecuteAll ProcessesAllAppFMx xxx x xxxx xxxxxxx x x x x xx x x x xxx x xxxxxnewworldsystems.comLast Saved: 5/25/18 8:52 AM

New World Systems8BANK RECONCILIATION PROCESSINGFMFMReturned Check Edit/PostListingReturned Check ErrorListingReturned Check G/LDistribution SummaryReturned Check ProcessingFMReverse License PaymentFMFMFMFMFMFMFMFMFMBank Reconciliation ProcessingFile: Bank Reconciliation Processing.docPrintReturned Check- ValidateFMView/UseFMFMDeleteReturned Check- PrintFMChangeFMFMDescriptionAddFMComponentReceipt Deposit BatchProcess Manager- PostReceipt Deposit BatchProcess Manager- Print Edit& Error ListingReceipt Deposit BatchProcess Manager- ValidateReceipt Deposit BatchProcessingReconcile Bank AccountBatch Edit/Post ListingReconcile Bank AccountBatch Error ListingReconcile Bank AccountBatch Process ManagerExecute All ProcessesReconcile Bank AccountBatch Process ManagerPostReconcile Bank AccountBatch Process ManagerPrint Edit & Error listingReconcile Bank AccountBatch Process ManagerValidateReconcile Bank AccountProcessingReturned Check- ExecuteAll ProcessesReturned Check- PostAllAppFMnewworldsystems.comLast Saved: 5/25/18 8:52 AM

New World Systems9BANK RECONCILIATION tReverse License PaymentEdit/post ListingReverse MiscellaneousBilling PaymentReverse MiscellaneousBilling Payment Edit/PostListingReverse Permit PaymentAllAppFMReverse Permit PaymentEdit/Post listingTreasurer’s Daily StatementTreasurers ReconciliationReportPermission Type – Company ApplicationsFeature Group – Payment Reconciliation AppFMComponent8.1 Payment RegisterFMACH Transmittal File ListingFMCash Requirement ListingFMCreate Payment RegisterFMPayment ReconciliationBatchesPayment ReconciliationBatches- Process ManagerApprovePayment ReconciliationBatches- Process ManagerPostPayment ReconciliationBatches- Process ManagerPrintPayment ReconciliationBatches- Process ManagerValidateFMFMFMFMBank Reconciliation ProcessingFile: Bank Reconciliation Processing.docDescriptionxxxxxxx xx x xxxxx xxxxxxxx x x x x xnewworldsystems.comLast Saved: 5/25/18 8:52 AM

New World Systems10BANK RECONCILIATION PROCESSINGFile: Bank Reconciliation Processing.docPrintBank Reconciliation ProcessingView/UsePayments- ReverseReconciled ments- EnterReconciliation AmountPayments- Import BankReconciliation DataPayments- ReconciliationAllAppFMx x x x xxxxx x xxxnewworldsystems.comLast Saved: 5/25/18 8:52 AM

New World Systems11BANK RECONCILIATION PROCESSINGProcess ManagerProcess Manager Security for Bank Reconciliation is used for Bank AccountJournals and Reconciling payments only. Processing Bank Deposits andReconciling the month’s Bank Statement do not allow for approval levelsbefore posting. This portion of security allows for the municipality to selecthow many approval levels for each process are needed before thetransaction is allowed to be posted, which departments can process BankAccount Journals and Reconcile checks, and which users are at eachapproval level.Maintenance Logos Suite Process ManagerTo assign the number of approval levels the transaction must pass through,and select which departments may create the transaction, highlight thedesired process. Next click the Setup Departments button.Bank Reconciliation ProcessingFile: Bank Reconciliation Processing.docnewworldsystems.comLast Saved: 5/25/18 8:52 AM

New World Systems12BANK RECONCILIATION PROCESSINGThe Approval Levels plus and minus buttons can be used to add or subtractapproval levels desired for the selected process. These levels can be namedaccording to the municipality’s criteria. Common naming conventions usedare Entry Level for Level 1 and Finance Approval for Level 2.Once the desired number of approval levels are selected and named, thenext step will be to assign all Departments to this process, and the selectednumber of approval levels. Move the desired Departments to the SelectedDepartments box by highlighting them, clicking the single arrow buttonbetween the boxes, and then clicking Save.Individual Departments can be modified with different approval levels anddifferent naming conventions on those levels if needed.Once the approval structure has been created, the next step will be to assignusers to the levels. Click the Manager workflow tab to select users to add tolevels per process.Bank Reconciliation ProcessingFile: Bank Reconciliation Processing.docnewworldsystems.comLast Saved: 5/25/18 8:52 AM

New World Systems13BANK RECONCILIATION PROCESSINGThe value selected in the Process drop-down will determine which processthe user will be added to. The Approval Level drop-down allows a user to beinputted at any level within a process for one or multiple Departments at atime.User Based Security/Sub Ledgers FunctionThere are two sub ledgers that must be set up in User-Based Security forBank Reconciliation: Bank Reconciliation and Payment Processing.The Sub Ledgers Function on the General Tab within User Based Security isshown below:Maintenance Log

Bank Reconciliation Processing newworldsystems.com File: Bank Reconciliation Processing.doc Last Saved: 5/25/18 8:52 AM New World Systems 5 BANK RECONCILIATION PROCESSING Maintenance Logos Suite Security Security Templates To create a new template

Related Documents:

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 .

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.

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.

Bank Reconciliation Statement is a statement prepared, periodically with a view to enlist the reasons for difference between the balances as per the bank column of the cashbook and pass book/bank statement on any given date. Need of preparing Bank Reconciliation Statement A Bank Reconciliation

M/s G.M. Kapadia & Co., Chartered Accountants Bankers HDFC Bank Ltd. (Primary Banker) Axis Bank Ltd. Bank of Baroda Bandhan Bank Ltd. Citibank N.A. CSB Bank Ltd. DCB Bank Ltd. Deutsche Bank ESAF Small Finance Bank ICICI Bank Ltd. IDFC Bank Ltd. Indian Bank RBL Bank Ltd. Saraswat Co-op Bank Ltd. State Bank of India Suryoday Small Finance Bank Ltd.

Cambridge IGCSE ACCOUNTING 0452/22 Paper 2 May/June 2020 MARK SCHEME Maximum Mark: 120 Published Students did not sit exam papers in the June 2020 series due to the Covid-19 global pandemic. This mark scheme is published to support teachers and students and should be read together with the question paper. It shows the requirements of the exam. The answer column of the mark scheme shows the .