Sage Bank i ng C o m m o n l y U s e d S e r v i c e s
1
Nav i ga t i ng t o B a n k S e r v i c e s
• E x p a n d C o m m o n S e r v i c e s • E x p a n d B a n k S e r v i c e s • S e l e c t B a n k T r a n s a c t i o n s
2
Ban k S e r v i c e s
Mo s t Common l y Us ed Fun c t i on s : 1 . Re conc i l e S t a t emen t s 2 . Bank Tran s fe r s 3 . Bank Ent r y 4 . Reve r s e Tran s a c t i on s 5 . BA I Impo r t ( m a n u a l l y i n s t a l l e d )
3
Re con c i l e S t a t emen t s
This is where you will clear the Sage activity that has cleared the bank account. 1. Bank Code – Each bank should have its own bank code 2. Bank description will auto populate once bank code is selected. • CMA##### - Cash Management Account • DEP##### - Depository Account/Legacy • DP2##### - Depository Account/Legacy • GMM##### - General Manager Account • OPR##### - Operating account 3. Reconciliation Description: you fill this out with your own description. Sample: Month, YYYY CMA reconciliation 4. Statement date: Bank Statement Date/Bank Balance Date 5. Statement Balance: Bank Balance 6. Reconciliation Date: Date the recon is being completed for 7. Out of Balance: you have not entered/cleared the bank activity that has occurred 4
Re con c i l e S t a t emen t s
5
Ban k Tr an s f e r s M a n u a l E n t r y
Only to be used to record activity when Bank Accounts have corresponding Bank Codes. Example: CMA fund transfers to OPR (transfer activity between 1 property with multiple banks) **This does not qualify for Atrium Finance 1/HRO funding/sweeps
1. Transfer number will auto populate
2. Transfer Posting Date: Date of bank activity transfer
3. Description: Bank Description
4. Reference: Bank Reference 5. Transfer From Bank Code: the bank code account with the withdrawal 6. Transfer To Bank Code: the bank code account with the deposit 7. Transfer Amount = Deposit Amount 8. Service Charges: If a service charge was applied to the account(s) this is where you can record rather than doing a separate bank entry.
6
Ban k Tr an s f e r s M a n u a l E n t r y
7
Ban k En t r y M a n u a l E n t r y
1. Entry number will auto populate 2. Entry Description: Bank Description. Sometimes the description should be changed for the better. Example ADP activity: ADP Wages PPE Wk#, ADP Taxes PPE Wk#, ADP Garnishments PPE Wk#, ADP 401K PPE Wk#. 3. Bank Code: the bank code account with the activity
4. Bank Entry Type: Withdrawal/Deposit • Withdrawal = Bank Debit = GL Credit • Deposit = Bank Credit = GL Debit 5. Bank Entry Date: Bank activity Date
6. G/L Account: Select the GL Account to be impacted by the bank activity. Example: ADP Wages: #####-020-21000085
7. Amount = Deposit/Withdrawal Amount 8. Reference: Bank Reference
8
Ban k En t r y M a n u a l E n t r y
9
Reve r s e Tr an s a c t i on s
If you find you have made a bank entry in error (i.e. duplicate or to the wrong bank code) you go to reverse transactions to reverse the bank entry. The entry should not be cleared in reconcile statements prior to reversal
1. Bank Code: the bank code account with the activity
2. Bank Description: Will auto populate
3. Source Application: Bank Services 4. Reverse Document: Bank Entry Type: Withdrawal/Deposit – the way it was posted 5. Reason for Reversal: duplicate/entered to the wrong bank code 6. Bank Entry Number: Click on finder to see your selectable options (if what you are looking for is not there, double check to make sure the item has not been cleared in reconcile statement – you may need to unclear – it will not show up in this screen if cleared) 7. Bank Entry Date will auto populated 8. Reversal Date: Should be the same as bank entry date if reversing within the same period.
10
Reve r s e Tr an s a c t i on s
11
BA I Impo r t
The BAI import takes the BAI file you have downloaded from Wells Fargo and separates the activity into 3 to 4 parts. (This can be used instead of the manual services - #2 Transfers and #3 Bank Entries.) 1. Transfers – Activity occurring between two Sage Banks. When you click on Post Transfers: the activity will post in Sage 2. Bank Entries – Activity occurring in only one bank and possibly needs to recorded. Review is required for accuracy. Sometimes the description should be changed for the better. Example ADP activity: ADP Wages PPE Wk#, ADP Taxes PPE Wk#, ADP Garnishments PPE Wk#, ADP 401K PPE Wk#. When you click on Post Entries: the activity will post in Sage 3. Checks – Check activity that has cleared the bank. When you click on Reconcile Checks: the activity will be cleared in Sage Reconcile Statements. 4. NA – No action was taken with the activity due to BAI requirements – example: IJ deposit activity: this activity is already recorded via IJ import so this activity does not need a bank entry, it just needs to be manually cleared in the Sage Reconcile Statements module. ***This module does not come standard in Sage. If you do not already see it on the Bank Transactions screen, you will need to add it. (Configuration instructions follow this section.) 12
BA I Impo r t
13
C o n f i g u r a t i o n o f BA I I mp o r t
To add the BAI Import functionality, follow these steps:
1. In Sage, in the Bank transaction area, right-click in a blank space.
2. Select New > Program 3. Title the icon as “BAI Import” and make sure the All Users box is checked. This will create the icon so that all users can access. Click Next. 4. At the Command line, browse to find the program file which is located at \\Atriumapp02\sage\300\Macros\Wellsfargo_Integration. You will need to change the File Type to All Files in order to see the file.
5. Select WellsFargo Integration Template and click Open.
6. No other fields are necessary, so click Finish.
14
C o n f i g u r a t i o n o f BA I I mp o r t
15
Page 1 Page 2 Page 3 Page 4 Page 5 Page 6 Page 7 Page 8 Page 9 Page 10 Page 11 Page 12 Page 13 Page 14 Page 15Made with FlippingBook - Online magazine maker