NatWest Bank File Generator Generate bank payment files for vendor payments from Zoho Books
Generate Bank File
@if(!$zohoConnected)
@else @if($errorMessage) @endif @if($successMessage) @endif
Company Bank Details Required

Enter your company's bank account details below (these can be saved in .env for future use)

Format: XX-XX-XX (e.g., 60-10-00)
@error('debitSortCode')
{{ $message }}
@enderror
8-digit account number
@error('debitAccount')
{{ $message }}
@enderror
@error('fromDate')
{{ $message }}
@enderror
@error('toDate')
{{ $message }}
@enderror
Note: This will fetch vendor payments from Zoho Books for the selected date range and generate a CSV file with payment details.
How it works:
  1. Select the date range for vendor payments
  2. Click "Generate & Download File"
  3. The system will fetch vendor payments from Zoho Books
  4. Vendor details including Sort Code and Account Number will be retrieved
  5. A CSV file with payment details will be generated and downloaded
CSV Format - NatWest Standard Domestic Payment:
  • T001: Record type (01 = standard domestic payment)
  • T010: Debit account (your company account)
  • T014: Payment amount (decimal format, e.g., 166.42)
  • T016: Date payment to arrive (DDMMYYYY)
  • T022: Beneficiary sort code
  • T028: Beneficiary account number
  • T030: Beneficiary name
  • T034: Payment reference
@endif
@if($zohoConnected)
Configuration
Organization ID:
{{ $organizationId }}
Zoho Connection:
Connected
Debit Account:
@if($debitSortCode && $debitAccount) {{ $debitSortCode }} - {{ $debitAccount }} @else Not configured @endif
Tip: To avoid entering these details each time, add to your .env file: 
NATWEST_DEBIT_SORT_CODE=12-34-56
NATWEST_DEBIT_ACCOUNT=12345678
@endif
@script @endscript