Auditoria da Importação

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

Linha Status Erro Dados Brutos (raw_data) Dados Mapeados (mapped_data)
#601 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":17.94,"FITID":false,"CHECKNUM":"111522","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":17.94,"net_amount":17.94,"fee_amount":0,"amount":17.94,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#602 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":56,"FITID":false,"CHECKNUM":"111530","NAME":"","MEMO":"CRE PIX CH","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":56,"net_amount":56,"fee_amount":0,"amount":56,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"settlemen...
#603 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":40.56,"FITID":false,"CHECKNUM":"111533","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":40.56,"net_amount":40.56,"fee_amount":0,"amount":40.56,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#604 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":38,"FITID":false,"CHECKNUM":"111536","NAME":"","MEMO":"CRE PIX CH","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":38,"net_amount":38,"fee_amount":0,"amount":38,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"settlemen...
#605 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":5,"FITID":false,"CHECKNUM":"111541","NAME":"","MEMO":"CRE PIX CH","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":5,"net_amount":5,"fee_amount":0,"amount":5,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"settlement",...
#606 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":10.99,"FITID":false,"CHECKNUM":"111546","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":10.99,"net_amount":10.99,"fee_amount":0,"amount":10.99,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#607 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":5,"FITID":false,"CHECKNUM":"111549","NAME":"","MEMO":"CRED PIX","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":5,"net_amount":5,"fee_amount":0,"amount":5,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"settlement",...
#608 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":47.74,"FITID":false,"CHECKNUM":"111553","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":47.74,"net_amount":47.74,"fee_amount":0,"amount":47.74,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#609 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":59.99,"FITID":false,"CHECKNUM":"111600","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":59.99,"net_amount":59.99,"fee_amount":0,"amount":59.99,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#610 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":34.98,"FITID":false,"CHECKNUM":"111606","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":34.98,"net_amount":34.98,"fee_amount":0,"amount":34.98,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#611 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":15.98,"FITID":false,"CHECKNUM":"111610","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":15.98,"net_amount":15.98,"fee_amount":0,"amount":15.98,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#612 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":24.3,"FITID":false,"CHECKNUM":"111619","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":24.3,"net_amount":24.3,"fee_amount":0,"amount":24.3,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"set...
#613 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":9.98,"FITID":false,"CHECKNUM":"111653","NAME":"","MEMO":"CRE PIX CH","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":9.98,"net_amount":9.98,"fee_amount":0,"amount":9.98,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"set...
#614 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":23.5,"FITID":false,"CHECKNUM":"111713","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":23.5,"net_amount":23.5,"fee_amount":0,"amount":23.5,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"set...
#615 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":122.45,"FITID":false,"CHECKNUM":"111715","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":122.45,"net_amount":122.45,"fee_amount":0,"amount":122.45,"date":"2026-03-11","transaction_type":"bank_transaction","event_type...
#616 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":49.64,"FITID":false,"CHECKNUM":"111717","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":49.64,"net_amount":49.64,"fee_amount":0,"amount":49.64,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#617 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":25.99,"FITID":false,"CHECKNUM":"111726","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":25.99,"net_amount":25.99,"fee_amount":0,"amount":25.99,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#618 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":33.48,"FITID":false,"CHECKNUM":"111728","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":33.48,"net_amount":33.48,"fee_amount":0,"amount":33.48,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#619 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":15.73,"FITID":false,"CHECKNUM":"111729","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":15.73,"net_amount":15.73,"fee_amount":0,"amount":15.73,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#620 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":90.04,"FITID":false,"CHECKNUM":"111732","NAME":"","MEMO":"CRED PIX","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":90.04,"net_amount":90.04,"fee_amount":0,"amount":90.04,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#621 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":7.5,"FITID":false,"CHECKNUM":"111736","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":7.5,"net_amount":7.5,"fee_amount":0,"amount":7.5,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"settle...
#622 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":38,"FITID":false,"CHECKNUM":"111741","NAME":"","MEMO":"CRED PIX","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":38,"net_amount":38,"fee_amount":0,"amount":38,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"settlemen...
#623 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":34.89,"FITID":false,"CHECKNUM":"111816","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":34.89,"net_amount":34.89,"fee_amount":0,"amount":34.89,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#624 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":286,"FITID":false,"CHECKNUM":"111827","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":286,"net_amount":286,"fee_amount":0,"amount":286,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"settle...
#625 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":4.99,"FITID":false,"CHECKNUM":"111839","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":4.99,"net_amount":4.99,"fee_amount":0,"amount":4.99,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"set...
#626 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":47.07,"FITID":false,"CHECKNUM":"111933","NAME":"","MEMO":"CRE PIX CH","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":47.07,"net_amount":47.07,"fee_amount":0,"amount":47.07,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#627 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":62.39,"FITID":false,"CHECKNUM":"111933","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":62.39,"net_amount":62.39,"fee_amount":0,"amount":62.39,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#628 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":34.1,"FITID":false,"CHECKNUM":"112003","NAME":"","MEMO":"CRE PIX CH","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":34.1,"net_amount":34.1,"fee_amount":0,"amount":34.1,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"set...
#629 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":28.99,"FITID":false,"CHECKNUM":"112008","NAME":"","MEMO":"CRE PIX CH","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":28.99,"net_amount":28.99,"fee_amount":0,"amount":28.99,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#630 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":25.37,"FITID":false,"CHECKNUM":"112009","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":25.37,"net_amount":25.37,"fee_amount":0,"amount":25.37,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#631 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":306.73,"FITID":false,"CHECKNUM":"112015","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":306.73,"net_amount":306.73,"fee_amount":0,"amount":306.73,"date":"2026-03-11","transaction_type":"bank_transaction","event_type...
#632 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":37.28,"FITID":false,"CHECKNUM":"112029","NAME":"","MEMO":"CRE PIX CH","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":37.28,"net_amount":37.28,"fee_amount":0,"amount":37.28,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#633 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":20.47,"FITID":false,"CHECKNUM":"112044","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":20.47,"net_amount":20.47,"fee_amount":0,"amount":20.47,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#634 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":13.99,"FITID":false,"CHECKNUM":"112102","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":13.99,"net_amount":13.99,"fee_amount":0,"amount":13.99,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#635 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":306.28,"FITID":false,"CHECKNUM":"112104","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":306.28,"net_amount":306.28,"fee_amount":0,"amount":306.28,"date":"2026-03-11","transaction_type":"bank_transaction","event_type...
#636 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":51.49,"FITID":false,"CHECKNUM":"112105","NAME":"","MEMO":"CRE PIX CH","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":51.49,"net_amount":51.49,"fee_amount":0,"amount":51.49,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#637 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":37.9,"FITID":false,"CHECKNUM":"112105","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":37.9,"net_amount":37.9,"fee_amount":0,"amount":37.9,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"set...
#638 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":18.99,"FITID":false,"CHECKNUM":"112106","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":18.99,"net_amount":18.99,"fee_amount":0,"amount":18.99,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#639 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":10.5,"FITID":false,"CHECKNUM":"112115","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":10.5,"net_amount":10.5,"fee_amount":0,"amount":10.5,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"set...
#640 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":36,"FITID":false,"CHECKNUM":"112124","NAME":"","MEMO":"CRE PIX CH","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":36,"net_amount":36,"fee_amount":0,"amount":36,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"settlemen...
#641 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":66.62,"FITID":false,"CHECKNUM":"112231","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":66.62,"net_amount":66.62,"fee_amount":0,"amount":66.62,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...
#642 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":23.9,"FITID":false,"CHECKNUM":"112253","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":23.9,"net_amount":23.9,"fee_amount":0,"amount":23.9,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"set...
#643 Concluída
{"TRNTYPE":"CREDIT","DTPOSTED":"20260311120000","TRNAMT":37.78,"FITID":false,"CHECKNUM":"112257","NAME":"","MEMO":"C PIX QRES","BANKID":false,"ORG":null,"source_system":"Extrato OFX"}
Usar no parser
{"transaction_date":"2026-03-11","transaction_datetime":"2026-03-11 12:00:00","gross_amount":37.78,"net_amount":37.78,"fee_amount":0,"amount":37.78,"date":"2026-03-11","transaction_type":"bank_transaction","event_type":"...