generate a bank statement pdf with some duplicate entries
- User
generate a bank statement pdf with some duplicate entries
Assistant
Generating a Bank Statement PDF with Duplicate Entries
Here's a Python script that creates a PDF bank statement with some duplicate entries using the
reportlablibrary. This example includes both legitimate transactions and duplicate entries to simulate potential errors.from reportlab.lib.pagesizes import letter from reportlab.lib import colors from reportlab.platypus import SimpleDocTemplate, Table, TableStyle, Paragraph from reportlab.lib.styles import getSampleStyleSheet from datetime import datetime, timedelta import random def generate_bank_statement(): # Create a document doc = SimpleDocTemplate("BankStatement.pdf", pagesize=letter) # Sample data account_holder = "John Doe" account_number = "1234567890123456" statement_date = datetime.now().strftime("%B %d, %Y") balance = 5000.00 # Generate transactions (including some duplicates) transactions = [] for i in range(1, 21): date = (datetime.now() - timedelta(days=random.randint(1, 30))).strftime("%m/%d/%Y") description = f"Transaction {i}" amount = round(random.uniform(10.0, 500.0), 2) # Add some duplicate entries if i in [3, 7, 12, 15, 18]: transactions.append([date, description, f"${amount:.2f}"]) transactions.append([date, description, f"${amount:.2f}"]) # Duplicate transactions.append([date, description, f"${amount:.2f}"]) # Create content styles = getSampleStyleSheet() elements = [] # Header header = Paragraph(f"<b>Bank Statement</b>", styles['Title']) account_info = Paragraph(f"Account Holder: {account_holder}<br/>Account Number: {account_number}<br/>Statement Date: {statement_date}", styles['Normal']) balance_info = Paragraph(f"<b>Current Balance: ${balance:.2f}</b>", styles['Heading2']) elements.extend([header, account_info, balance_info]) # Table for transactions table_data = [["Date", "Description", "Amount"]] + transactions table = Table(table_data, colWidths=[1.5*72, 3*72, 1.5*72]) # 72 points = 1 inch # Style the table table.setStyle(TableStyle([ ('BACKGROUND', (0, 0), (-1, 0), colors.grey), ('TEXTCOLOR', (0, 0), (-1, 0), colors.whitesmoke), ('ALIGN', (0, 0), (-1, -1), 'CENTER'), ('FONTNAME', (0, 0), (-1, 0), 'Helvetica-Bold'), ('FONTSIZE', (0, 0), (-1, 0), 12), ('BOTTOMPADDING', (0, 0), (-1, 0), 12), ('BACKGROUND', (0, 1), (-1, -1), colors.beige), ('GRID', (0, 0), (-1, -1), 1, colors.black), ('ROWBACKGROUNDS', (0, 1), (-1, -1), [colors.white, colors.lightgrey]), ])) elements.append(table) # Build the document doc.build(elements) print("Bank statement PDF generated with duplicate entries.") if __name__ == "__main__": generate_bank_statement()How to Use This Script
- Make sure you have Python installed on your system
- Install the required library:
pip install reportlab - Run the script:
python bank_statement.py - The script will generate a PDF file named "BankStatement.pdf" with duplicate entries
Features of the Generated PDF:
- Professional bank statement format
- Account holder information
- Current balance
- Transaction table with:
- Date
- Description
- Amount
- Duplicate entries (transactions 3, 7, 12, 15, and 18 are duplicated)
- Clean, readable formatting with alternating row colors
You can modify the script to include more or fewer duplicate entries, change the account information, or adjust the transaction amounts as needed.
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.