Auditoria da Importação

Arquivo: EXTRATO CAIXA FARMACIA MARÇO 2026 24-31 OFX.ofx • Empresa: FARMACIA MELISSA LTDA

Linha Status Erro Dados Brutos (raw_data) Dados Mapeados (mapped_data)
#701 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":13.5,"FITID":false,"CHECKNUM":"311854","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":13.5,"net_amount":13.5,"fee_amount":0,"amount":13.5,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"set...
#702 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":9.97,"FITID":false,"CHECKNUM":"311905","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":9.97,"net_amount":9.97,"fee_amount":0,"amount":9.97,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"set...
#703 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":14.99,"FITID":false,"CHECKNUM":"311911","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":14.99,"net_amount":14.99,"fee_amount":0,"amount":14.99,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"...
#704 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":249.11,"FITID":false,"CHECKNUM":"311913","NAME":"","MEMO":"CRED PIX","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":249.11,"net_amount":249.11,"fee_amount":0,"amount":249.11,"date":"2026-03-31","transaction_type":"bank_transaction","event_type...
#705 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":30.4,"FITID":false,"CHECKNUM":"311914","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":30.4,"net_amount":30.4,"fee_amount":0,"amount":30.4,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"set...
#706 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":3,"FITID":false,"CHECKNUM":"311923","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":3,"net_amount":3,"fee_amount":0,"amount":3,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"settlement",...
#707 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":14.12,"FITID":false,"CHECKNUM":"311930","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":14.12,"net_amount":14.12,"fee_amount":0,"amount":14.12,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"...
#708 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":39.99,"FITID":false,"CHECKNUM":"311958","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":39.99,"net_amount":39.99,"fee_amount":0,"amount":39.99,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"...
#709 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":35,"FITID":false,"CHECKNUM":"312002","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":35,"net_amount":35,"fee_amount":0,"amount":35,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"settlemen...
#710 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":19.99,"FITID":false,"CHECKNUM":"312003","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":19.99,"net_amount":19.99,"fee_amount":0,"amount":19.99,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"...
#711 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":10,"FITID":false,"CHECKNUM":"312006","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":10,"net_amount":10,"fee_amount":0,"amount":10,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"settlemen...
#712 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":41,"FITID":false,"CHECKNUM":"312007","NAME":"","MEMO":"CRE PIX CH","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":41,"net_amount":41,"fee_amount":0,"amount":41,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"settlemen...
#713 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":44.98,"FITID":false,"CHECKNUM":"312012","NAME":"","MEMO":"CRED PIX","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":44.98,"net_amount":44.98,"fee_amount":0,"amount":44.98,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"...
#714 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":41.89,"FITID":false,"CHECKNUM":"312013","NAME":"","MEMO":"CRED PIX","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":41.89,"net_amount":41.89,"fee_amount":0,"amount":41.89,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"...
#715 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":22.5,"FITID":false,"CHECKNUM":"312024","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":22.5,"net_amount":22.5,"fee_amount":0,"amount":22.5,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"set...
#716 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":28.5,"FITID":false,"CHECKNUM":"312024","NAME":"","MEMO":"CRED PIX","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":28.5,"net_amount":28.5,"fee_amount":0,"amount":28.5,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"set...
#717 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":43.71,"FITID":false,"CHECKNUM":"312026","NAME":"","MEMO":"CRE PIX CH","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":43.71,"net_amount":43.71,"fee_amount":0,"amount":43.71,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"...
#718 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":41.44,"FITID":false,"CHECKNUM":"312028","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":41.44,"net_amount":41.44,"fee_amount":0,"amount":41.44,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"...
#719 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":35,"FITID":false,"CHECKNUM":"312035","NAME":"","MEMO":"CRE PIX CH","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":35,"net_amount":35,"fee_amount":0,"amount":35,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"settlemen...
#720 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":21.5,"FITID":false,"CHECKNUM":"312035","NAME":"","MEMO":"CRE PIX CH","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":21.5,"net_amount":21.5,"fee_amount":0,"amount":21.5,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"set...
#721 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":69.49,"FITID":false,"CHECKNUM":"312054","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":69.49,"net_amount":69.49,"fee_amount":0,"amount":69.49,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"...
#722 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":23.08,"FITID":false,"CHECKNUM":"312101","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":23.08,"net_amount":23.08,"fee_amount":0,"amount":23.08,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"...
#723 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":95.99,"FITID":false,"CHECKNUM":"312128","NAME":"","MEMO":"CRE PIX CH","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":95.99,"net_amount":95.99,"fee_amount":0,"amount":95.99,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"...
#724 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":1,"FITID":false,"CHECKNUM":"312129","NAME":"","MEMO":"CRE PIX CH","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":1,"net_amount":1,"fee_amount":0,"amount":1,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"settlement",...
#725 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":16.89,"FITID":false,"CHECKNUM":"312217","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":16.89,"net_amount":16.89,"fee_amount":0,"amount":16.89,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"...
#726 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":169.96,"FITID":false,"CHECKNUM":"312220","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":169.96,"net_amount":169.96,"fee_amount":0,"amount":169.96,"date":"2026-03-31","transaction_type":"bank_transaction","event_type...
#727 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260331120000","TRNAMT":58.93,"FITID":false,"CHECKNUM":"312225","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-31","transaction_datetime":"2026-03-31 12:00:00","gross_amount":58.93,"net_amount":58.93,"fee_amount":0,"amount":58.93,"date":"2026-03-31","transaction_type":"bank_transaction","event_type":"...