Notes

def get_page_wise_deposits(extracted_raw_text):

model = genai.GenerativeModel('gemini-pro')
prompt_with_pdf_text = f"""Your task is to provide Deposits/credits details in table format [follow this strictly].
use delimeter '|' to separate columns data, use only two as shown in example.
If there are no deposits on the page, simply respond with "not found" without creating any dummy data not present in the given document.
Example :
Note: Consider this as an example only, do not include it in the output.[follow this strictly]
Table Name: Deposits Table
Date |Description | Amount
XYZ |XYZ | XYZ

some time Deposits/credits transaction can be continued from one page to next page and present with 'continued' at the end on table heading.
use your undestanding to find Deposits/credits transaction and Deposits transaction you can extract it based on description details.
Do not consider any nigative transaction as Deposits/credits transaction. [follow this strictly]
Do not consider any transaction from 'Withdrawals/Debits' table as Deposits/credits transaction. [follow this strictly]
Some times deposit transaction and withdrawal/Deduction transaction can possible to come below each other but your task is to consider Deposit type of transaction only.
Some time you find diffrent section for deposit and diffrent section for withdrawal/Deduction transactions.
Sometimes deposit transactions and withdrawal/deduction transactions can appear in two different columns under a single table. In such a case, consider the entire 'Credits' or 'Deposits' or 'Additions' column as containing deposit transactions.
Do not consider any transactions from the 'Subtractions' column as 'deposit transaction'
Some time page do not have any transaction related 'Deposits/credits' data then ignore all data.
Remember not to consider any type of transaction that involves the process of taking money out of a bank account.[follow this strictly]
refer those transactions from bank statemet which having date refrence and description refrence. [follow this strictly]
If description is not present then do not create description from your side, also do not consider such type of transactions.
Please remember you are answering on Bank statement single page. Answer all details assuming you are perfect accountant.
Remember not to consider any transactions from 'DAILY ENDING BALANCE' as deposit transaction also any type of withdrawals transaction.
remember to provide Amount in float value only.[follow this strictly]
example:
if amount in input text like '10,337.00'
provide amount in float format like '10337.00'
Remember to provide Short description details .[follow this strictly]
example :
Description text if like '5/3 ONLINE TRANSFER FROM CK: XXXXXX4283 REF # 00906286638'
provide short description like '5/3 ONLINE TRANSFER FROM'
Description text if like'Orig CO Name:Quikq, LLC Orig ID:1371859719 Desc Date: CO Entry Descr:14610Bd48Csec:CCD Trace#:081000038240121 Eed:240103 ID:Lm9NH9Wb4HI5 Ind Name:Jhd Transport Inc Trn: 0038240121Tc'
provide short description like 'Orig CO Name:Quikq, LLC Orig'

If nothing is found, say 'not found' only. Do not create any data or table from yor side. [follow this strictly]
{extracted_raw_text}
"""

try:
response = get_completion(prompt_with_pdf_text)

if response is None:
return 'not found'
return response

except Exception as e:
return f"An error occurred: {e}"