How to use ChatGPT for Accounts Receivable Administrator Job Role

python

   import pdfplumber
   with pdfplumber.open('invoice.pdf') as pdf:
       first_page = pdf.pages[0]
       text = first_page.extract_text()
   

python

   import re
   invoice_number = re.search(r'Invoice Number: (\d+)', text).group(1)
   date = re.search(r'Date: (\d{2}/\d{2}/\d{4})', text).group(1)
   customer_name = re.search(r'Customer: (.+)', text).group(1)
   

python

   import csv
   with open('invoice_data.csv', mode='w', newline='') as file:
       writer = csv.writer(file)
       writer.writerow(['Invoice Number', 'Date', 'Customer Name', 'Item Description', 'Quantity', 'Unit Price', 'Total'])
       writer.writerow([invoice_number, date, customer_name, item_description, quantity, unit_price, total])
   

python

   import pandas as pd
   df = pd.read_excel('accounts_receivable.xlsx')
   

python

   print(df.head())
   

python

   from datetime import datetime
   today = datetime.now().date()
   overdue_accounts = df[df['Due Date'] < today]
   

python

   total_overdue = overdue_accounts['Amount Due'].sum()
   summary_report = overdue_accounts[['Invoice Number', 'Customer Name', 'Due Date', 'Amount Due']]
   

python

   summary_report.to_excel('overdue_accounts_summary.xlsx', index=False)