SOP: BANKING
U P DAT E D A P R I L 2 0 1 9
B A N K I N G P R O C E S S | I N C O M E J O U R N A L R E C E I V E D B Y D E A D L I N E
B A N K I N G P R O C E S S | I N C O M E J O U R N A L R E C E I V E D B Y D E A D L I N E
Step
Tasks
0. Reports Received from DOA
Review documentation to ensure proper day Reports due by 10 AM local time for prior day, weekends due by 3 PM local time
1. Pull Daily Activity in Wells Fargo Log into WF
Download ACH Origination Report in Excel format Download Previous Day Composite Report in Excel format Download Previous Day Composite Report in BAI format Download Previous Day Balance
2a. Review Income Journal in Profit Sage Review documentation and ensure it supports the IJ Confirm revenue Confirm credit cards (FD and F&B) Confirm cash Cross-check check log to check deposit Confirm tips Confirm ledger balances Confirm banquets Review manual adjustments
Review misc non-revenue (for balance sheet related transactions)
2b. Export ProfitSage Reports
Download reports in excel format and input reports into Depository Reconciliation tabs Run, download, and copy/paste Accounts by Day Report in Excel format Run, download, and copy/paste Download Daily Cash in Excel format Run, download, and copy/paste Credit Card Commissions Report in Excel format
3a. Post GL and banking entries in Sage 300 Import IJ into Sage Go into G/L module
Open entry and spot check to verify correct day's data Post Go into bank module Open post entries module and look for duplicate data Post
3b. Review & Import Wells Fargo BAI Activity mport BAI file in Sage
4. Match daily deposits to depository spreadsheet Match Cash deposits in WF to spreadsheet from ProfitSage Match CC deposits in WF to spreadsheet from ProfitSage Match Chargebacks in WF to spreadsheet from ProfitSafe
5. Post Bank Activity not on BAI Tool GM Checks: Create invoice and reconcile in Sage
Concur Batches: Reviewed by DOA, entry created through Payment Batch List, reconciled in Sage ACH Deposits with identification: Antenna Income/CSI Commissions/Universal Vending ACH Withdrawals grouped together (Fleet Card, CSI Vcard, other AP transactions) CSI Vcard
6. Sage Reconciliation
Update all account balances in Sage with Wells Fargo balance for the day DEP: Reconcile each item fromWF activity to it's matching Sage entry DEP: Reconcile each item fromWF activity to it's matching Sage entry OP: Reconcile each item fromWF activity to it's matching Sage entry GM: Reconcile each item fromWF activity to it's matching Sage entry
7. Balance Wells Fargo to Sage
Use property balancing tool for depository account Unable to calculate amounts to clear To do away with balancing tool, need a report in Sage
1 . P U L L D A I L Y A C T I V I T Y F R O M W E L L S F A R G O ( e x a m p l e : T o p e k a C a p i t o l P l a z a 3 / 2 6 / 1 9 b a n k a c t i v i t y )
Go to… https://wellsoffice.wellsfargo.com/portal/signon/index.jsp
Sign On with your Company ID, User ID and Password
1
Download 2 reports fromTreasury Information Reporting 1) ACH Origination 2) Previous Day Composite (Excel and BAI) 1) Pull ACH activity from ACH Origination Report
2
Select your property Topeka has 2 IDs
3
4
5
6
*You can create and save your Reports with your additional criteria
1
ACH Activity Excel opens
2
Copy
Copy ACH Activity and past the data to ‘Wells Fargo Activity Template’ excel found in Bank Rec folder (F:\Atrium Hospitality\All Hotels\144_TOPEK Topeka\Bank Recs\2019\Mar 2019)
3
Paste in ‘ACH’ tab
WIP – Should we include? Types of ACH Transactions explained: EDI PYMNTS >>> CSI VCARD >>>
2A . PUL L PREV IOUS DAY BANK ACT I V I T I ES FROM PREV IOUS DAY COMPOS I TE REPORT
1
2
Select your property Topeka has 3 IDs
3
4
5
6
Copy DEP_1101_TRAN and past the data to ‘Wells Fargo Activity Template’ excel
7
Copy
Copy ACH Activity and past the data to ‘Wells Fargo Activity Template’ excel found in Bank Rec folder (F:\Atrium Hospitality\All Hotels\144_TOPEK Topeka\Bank Recs\2019\Mar 2019)
8
Paste in ‘DEP_1101_TRAN’ tab (Make sure pasting appropriate columns)
Go back to the internet browser
1
Copy DEP_1101_BAL and past the data to ‘Wells Fargo Activity Template’ excel
2
Copy
3
Paste in ‘Balance’ tab
Check Point (1 of 2) In your Wells Fargo Activity Template excel is updated with Wells Fargo downloads ü ACH tab ü DEP_1101_TRAN tab ü Balance tab
2B . PUL L PREV IOUS DAY BANK ACT I V I T I ES FROM PREV IOUS DAY COMP S I TE REPORT ( BA I )
Go back to theWELLS FARGOTreasury Information Reporting
1
2
3
Select BAI v2
4
5
6
Click the triangle
Locate ‘BAI’ folder in Acumen Tools to save
7
8
File name should include bank activity date
9
Check Point (2 of 2) ü Wells Fargo BAI tool is saved in Acumen Tools
3 a . P O S T G L A N D B A N K I N G E N T R I E S I N S A G E 3 0 0 ( e x a m p l e : T o p e k a C a p i t o l P l a z a 3 / 2 6 / 1 9 b a n k a c t i v i t y )
Go to… Sage 300
Go into G/L module
1
4
Uncheck the box to show unposted batches
5
6
Find and click IJ Import unposted batch
2
3
7
8
Spot check to verify correct day’s data here - Dates - No misc. expense - No duplicate - Out of Balance check (must be zero)
9
Check Point (1 of 2) ü G/L IJ (Income Journal) entries are posted
Go to… Sage 300
Go into Bank module
1
4
2
Click Magnifying glass to shows a list of unposted bank entries. Look for duplicate data.
5
3
6
Once bank entries are posted, there is no unposted batches in the module
Check Point (2 of 2) ü Bank entries are posted
3 B . R E V I E W & I M P I O R T W E L L S F A R G O B A I A C T I V I T Y ( e x a m p l e : T o p e k a C a p i t o l P l a z a 3 / 2 6 / 1 9 b a n k a c t i v i t y )
Go to… Sage 300
Go into Bank module
1
4
Double click the icon so WellsFargo Integration Template will pop up
2
3
5
6
Locate the BAI tool you have saved in your Acumen Tools folder
7
9
8
1
2
Close Notepad
Page 1 Page 2 Page 3 Page 4 Page 5 Page 6 Page 7 Page 8 Page 9 Page 10 Page 11 Page 12Made with FlippingBook - professional solution for displaying marketing and sales documents online