Batch File Format

The generated batch file follows this format:

• Header Line: Begins with "H" followed by the merchant code (e.g., "H0Menethil")
• Data Lines: Each payment entry formatted with "DPARENT" prefix, followed by the ID and amount (e.g., "DPARENTtest1 0000455696")
• Total Line: Begins with "TTOTAL", followed by the total amount and record count (e.g., "TTOTAL 000210338200005")

H0Menethil
DPARENTtest1      0000455696
DPARENTtest2      0000186582
DPARENTtest3      0000230849
DPARENTtest4      0000460925
DPARENTtest5      0000769330
TTOTAL            000210338200005
            

Using the Spreadsheet

• Merchant Code: Must be entered before creating a file
• ID Column: Enter IDs (3-9 characters recommended)
• Amount Column: Enter positive numeric amounts (cannot be zero or negative)
• Click on cells to edit them, double-click to enter edit mode
• Press Tab or Enter to navigate between cells
• Ctrl+C to copy selected cells, Ctrl+V to paste data
• Use Shift+Click to select ranges of cells
• Press Delete or Backspace to clear selected cells
• Invalid entries will be highlighted in red (errors) or yellow (warnings)

Menu Options

• New: Clear all data and reset to a fresh spreadsheet
• Load CSV: Import data from a CSV file (must contain ID and Amount columns)
• Download Template: Download a CSV template with sample data for import
• Generate Data: Add random test data to the spreadsheet
• Create File: Generate and download the batch payment file after validating all data
• Download App: Create a standalone HTML file containing the full application for offline use
• Add Rows: Use the field at the bottom of the screen to add multiple rows at once

Note: Data is stored only in your browser and is not sent to any server.