Crie arquivos de relatórios financeiros por meio de Python

Criação de formatos de relatórios financeiros incluindo XBRL e OFX arquivo de solicitação ou resposta no formato 1.03 ou 2.2 em aplicativos baseados em Python.

Baixar
 

Aspose.Finance para Python via .NET é um recurso rico em recursos, extensível e fácil de usar para criação e processamento de relatórios financeiros API. Os desenvolvedores podem criar facilmente a instância XBRL do zero, bem como adicionar referência de esquema, contexto, unidade, item, link de nota de rodapé, referência de função e referência de função de arco. API fornece classe relevante para cada recurso, como para contexto, os desenvolvedores podem usar ContextPeriod, ContextEntity e Context. Além disso, API também oferece suporte à criação de solicitação/resposta no formato de troca financeira aberta (OFX) no formato 1.03 ou 2.2.

Criar arquivo XBRL adicionando item

Para criar o arquivo XBRL e adicionar um item ao documento, o processo é criar uma instância da classe XbrlDocument. Prepare configurações relevantes para o item usando classes API apropriadas, como a classe SchemaRef, classes de contexto relevantes, conforme mencionado acima, e a classe Concept. Por fim, defina e inicialize as propriedades da classe Item, bem como chame o método save para criar o arquivo XBRL no disco.

Python Código para criar arquivo XBRL adicionando item
xbrlDoc = XbrlDocument()
xbrlInstances = xbrlDoc.xbrl_instances
xbrlInstance = xbrlInstances[xbrlInstances.add()]
schemaRefs = xbrlInstance.schema_refs
schemaRefs.add(os.path.join(sourceDir, "schema.xsd"), "example", "http://example.com/xbrl/taxonomy")
schema = schemaRefs[0]
contextPeriod = ContextPeriod(datetime(2020,1,1), datetime(2020,2,10))
contextEntity = ContextEntity("exampleIdentifierScheme", "exampleIdentifier")
context = Context(contextPeriod, contextEntity)
xbrlInstance.contexts.append(context)
unit = Unit(UnitType.MEASURE)
unit.measure_qualified_names.append(QualifiedName("USD", "iso4217", "http://www.xbrl.org/2003/iso4217"))
xbrlInstance.units.append(unit)
fixedAssetsConcept = schema.get_concept_by_name("fixedAssets")
if fixedAssetsConcept is not None:
item = Item(fixedAssetsConcept)
item.context_ref = context
item.unit_ref = unit
item.precision = 4
item.value = "1444"
xbrlInstance.facts.append(item)
xbrlDoc.save(os.path.join(outputDir, "dochavingItem.xbrl"))
view raw create-xbrl-file-and-add-item.py hosted with ❤ by GitHub

Crie OFX arquivos de solicitação e resposta

Para gerar arquivos OFX, o API fornece as classes OfxRequestDocument e OfxResponseDocument e os desenvolvedores podem facilmente criar OFX Solicitação e arquivos de resposta nos formatos 1.03 e 2.2. Para inicializar as propriedades OfxRequestDocument, API também fornece outras classes, como as classes SignonRequest, FinancialInstitution e StatementTransactionRequest. Da mesma forma, para inicializar as propriedades OfxResponseDocument, API fornece classes de suporte, como SignonResponse, StatementTransactionResponse e StatementTransaction. Abaixo estão os trechos de código para ambos os casos com o uso de classes apropriadas relevantes.

Python Código para gerar OFX documentos de solicitação
ofxResponseDoc = OfxResponseDocument()
ofxResponseDoc.signon_response_message_set_v1 = SignonResponseMessageSetV1()
signonResponse = SignonResponse()
ofxResponseDoc.signon_response_message_set_v1.signon_response = signonResponse
signonResponse.status = Status()
signonResponse.status.code = "0"
signonResponse.status.severity = SeverityEnum.INFO
signonResponse.status.message = "SUCCESS"
signonResponse.server_date = "20200611"
signonResponse.profile_update_date = "20200611"
fi = FinancialInstitution()
fi.organization = "aspose"
fi.financial_institution_id = "1"
signonResponse.financial_institution = fi
signonResponse.session_cookie = "11111111111111111"
ofxResponseDoc.bank_response_message_set_v1 = BankResponseMessageSetV1()
stmtTransResponse = StatementTransactionResponse()
ofxResponseDoc.bank_response_message_set_v1.statement_transaction_responses.append(stmtTransResponse)
stmtTransResponse.transaction_unique_id = "829631324"
stmtTransResponse.status = Status()
stmtTransResponse.status.code = "0"
stmtTransResponse.status.severity = SeverityEnum.INFO
stmtTransResponse.statement_response = StatementResponse()
stmtTransResponse.statement_response.currency = CurrencyEnum.USD
stmtTransResponse.statement_response.bank_account_from = BankAccount()
stmtTransResponse.statement_response.bank_account_from.bank_id = "1111111"
stmtTransResponse.statement_response.bank_account_from.account_id = "1111111111111"
stmtTransResponse.statement_response.bank_account_from.account_type = AccountEnum.CHECKING
stmtTransResponse.statement_response.bank_transaction_list = BankTransactionList()
stmtTransResponse.statement_response.bank_transaction_list.start_date = "20200601000000"
stmtTransResponse.statement_response.bank_transaction_list.end_date = "20200611000000"
transaction1 = StatementTransaction()
transaction1.transaction_type = TransactionEnum.DEBIT
transaction1.posted_date = "20200611000000"
transaction1.transaction_amount = "-12"
transaction1.financial_institution_transaction_id = "1111111111111111111111111"
transaction1.name = "bbbbbbbbbbbbbbbbbbbbbbb"
transaction2 = StatementTransaction()
transaction2.transaction_type = TransactionEnum.CREDIT
transaction2.posted_date = "20200611000000"
transaction2.transaction_amount = "22222.11"
transaction2.financial_institution_transaction_id = "2222222222222222222222222222"
transaction2.name = "wwwwwwwwwwwwwwwwwwwwwwww"
stmtTransResponse.statement_response.bank_transaction_list.statement_transactions.append(transaction1)
stmtTransResponse.statement_response.bank_transaction_list.statement_transactions.append(transaction2)
stmtTransResponse.statement_response.ledger_balance = LedgerBalance()
stmtTransResponse.statement_response.ledger_balance.balance_amount = "+2222.42"
stmtTransResponse.statement_response.ledger_balance.date_as_of = "20200611000000"
stmtTransResponse.statement_response.available_balance = AvailableBalance()
stmtTransResponse.statement_response.available_balance.balance_amount = "+222222.42"
stmtTransResponse.statement_response.available_balance.date_as_of = "20200611000000"
ofxResponseDoc.save(os.path.join(outputDir,"newOfxResponseBankStatement.xml"), OfxVersionEnum.V2X)
ofxResponseDoc.save(os.path.join(outputDir,"newOfxResponseBankStatement.sgml"), OfxVersionEnum.V1X)
view raw create-ofx-response-files.py hosted with ❤ by GitHub
Python Código para gerar OFX documentos de resposta
ofxResponseDoc = OfxResponseDocument()
ofxResponseDoc.signon_response_message_set_v1 = SignonResponseMessageSetV1()
signonResponse = SignonResponse()
ofxResponseDoc.signon_response_message_set_v1.signon_response = signonResponse
signonResponse.status = Status()
signonResponse.status.code = "0"
signonResponse.status.severity = SeverityEnum.INFO
signonResponse.status.message = "SUCCESS"
signonResponse.server_date = "20200611"
signonResponse.profile_update_date = "20200611"
fi = FinancialInstitution()
fi.organization = "aspose"
fi.financial_institution_id = "1"
signonResponse.financial_institution = fi
signonResponse.session_cookie = "11111111111111111"
ofxResponseDoc.bank_response_message_set_v1 = BankResponseMessageSetV1()
stmtTransResponse = StatementTransactionResponse()
ofxResponseDoc.bank_response_message_set_v1.statement_transaction_responses.append(stmtTransResponse)
stmtTransResponse.transaction_unique_id = "829631324"
stmtTransResponse.status = Status()
stmtTransResponse.status.code = "0"
stmtTransResponse.status.severity = SeverityEnum.INFO
stmtTransResponse.statement_response = StatementResponse()
stmtTransResponse.statement_response.currency = CurrencyEnum.USD
stmtTransResponse.statement_response.bank_account_from = BankAccount()
stmtTransResponse.statement_response.bank_account_from.bank_id = "1111111"
stmtTransResponse.statement_response.bank_account_from.account_id = "1111111111111"
stmtTransResponse.statement_response.bank_account_from.account_type = AccountEnum.CHECKING
stmtTransResponse.statement_response.bank_transaction_list = BankTransactionList()
stmtTransResponse.statement_response.bank_transaction_list.start_date = "20200601000000"
stmtTransResponse.statement_response.bank_transaction_list.end_date = "20200611000000"
transaction1 = StatementTransaction()
transaction1.transaction_type = TransactionEnum.DEBIT
transaction1.posted_date = "20200611000000"
transaction1.transaction_amount = "-12"
transaction1.financial_institution_transaction_id = "1111111111111111111111111"
transaction1.name = "bbbbbbbbbbbbbbbbbbbbbbb"
transaction2 = StatementTransaction()
transaction2.transaction_type = TransactionEnum.CREDIT
transaction2.posted_date = "20200611000000"
transaction2.transaction_amount = "22222.11"
transaction2.financial_institution_transaction_id = "2222222222222222222222222222"
transaction2.name = "wwwwwwwwwwwwwwwwwwwwwwww"
stmtTransResponse.statement_response.bank_transaction_list.statement_transactions.append(transaction1)
stmtTransResponse.statement_response.bank_transaction_list.statement_transactions.append(transaction2)
stmtTransResponse.statement_response.ledger_balance = LedgerBalance()
stmtTransResponse.statement_response.ledger_balance.balance_amount = "+2222.42"
stmtTransResponse.statement_response.ledger_balance.date_as_of = "20200611000000"
stmtTransResponse.statement_response.available_balance = AvailableBalance()
stmtTransResponse.statement_response.available_balance.balance_amount = "+222222.42"
stmtTransResponse.statement_response.available_balance.date_as_of = "20200611000000"
ofxResponseDoc.save(os.path.join(outputDir,"newOfxResponseBankStatement.xml"), OfxVersionEnum.V2X)
ofxResponseDoc.save(os.path.join(outputDir,"newOfxResponseBankStatement.sgml"), OfxVersionEnum.V1X)
view raw create-ofx-response-files.py hosted with ❤ by GitHub