8-Attachment D Bank Recon File Layout.xlsx
XLSX spreadsheet 16 KB Posted
- Attached to
- RFP-2602AM Comprehensive Banking Services
- Solicitation number
- RFP-2602AM Comprehensive Banking Services
- Issued by
- Crisp County, Georgia
About this file
This document is an Excel spreadsheet (Attachment D) detailing a bank reconciliation file layout for Gwinnett County Public Schools, specifically for Accounts Payable and Payroll bank statement imports. The file layout provides a technical specification for data field positioning, including routing number, account number, check number, cleared date, and amount fields, with a fixed length of 80 characters per record. The file is associated with a Request for Proposal (RFP-2602AM) for Comprehensive Banking Services, with a contract term from July 1, 2026, through June 30, 2027.
The file layout demonstrates a structured approach to bank statement reconciliation, with precise field definitions including character and numeric positioning for key financial transaction elements. While the document does not provide specific pricing or financial details, it is part of a broader banking services procurement process for Gwinnett County Public Schools in Georgia. The technical specification suggests a need for precise data import and reconciliation capabilities, likely as part of a comprehensive banking services evaluation and selection process.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 10-RFP-2602AM Invitation and Proposal Requirements.pdf | ||
| 3-Solicitation Instructions and Conditions September 2025.pdf | ||
| 4-Euna Procurement (formerly Bonfire) Support Overview.pdf | ||
| 2-GCPS W-9 Substitute Supplier Info Forms 2024.pdf | ||
| 6-Attachment A Account Types and Services.pdf | ||
| 5-Attachment B Fee Proposal.xlsx | XLSX spreadsheet | |
| 7-Attachment C ECR.xls | XLS spreadsheet | |
| 1-Lobbying Certification.pdf | ||
| 9-Attachment E Merchant Service Fees.xlsx | XLSX spreadsheet |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
| ATTACHMENT D |
| Gwinnett County Public Schools |
| Accounts Payable and Payroll |
| Bank Statement Import - Reconciliation |
| FILE LAYOUT | |||||||||||||||||||||||||||||||||||||||||||||||||
| Field | Layout Identifier | Start Position | Length | Type | Decimal Position | ||||||||||||||||||||||||||||||||||||||||||||
| ROUTING_NUM | r | 1 | 2 | 3 | 4 | ||||||||||||||||||||||||||||||||||||||||||||
| ACCOUNT_NUM | a | 10 | 17 | Character | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 0 | 1 | 2 | 3 | 4 | |
| CHECK_NUM | c | 27 | 10 | Character | r | r | r | r | r | r | r | r | r | a | a | a | a | a | a | a | a | a | a | a | a | a | a | a | a | a | c | c | c | c | c | c | c | c | c | c | d | d | d | d | d | d | 9 | 9 | |
| CLEARED_DT | c | 37 | 6 | Date (MMDDYY) | ROUTING_NUM | ACCOUNT_NUM | CHECK_NUM | CLEARED_DT | AMOUNT | ||||||||||||||||||||||||||||||||||||||||
| AMOUNT | 9 | 43 | 17 | Signed Number | 0 | ** NOT USED ** | |||||||||||||||||||||||||||||||||||||||||||
| 0 | 60 | 21 |
Fixed length file consisting of 80 characters
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .