Dear all,
I’ve got a question. In one of the former versions of Manager.io Receipts/Payments were combined. In a later version these two are split up individual.
My problem
I have N26 as a bank and the only exports they offer are PDFs and CSV files. So unfortunately no MT940 files that can be read by Manager.io in terms of processing. The generated CSV is of course not Manager.io compatible either. What I did is modifying the CSV of N26 to the Manager.io format. Since the split up of the tabs (receipts/payments) this is no longer possible. The same goes for my creditcard provider (ICS) which only supports PDFs. Also exporting PDF data to a workable CSV format of Manager.io did the trick. However, since the split up I can’t simply process them anymore. Any tips & tricks?
Old format:
Date BankAccount Description Lines.Description Lines.Account Lines.TaxCode Lines.Qty Lines.Item Lines.Amount Lines.Debit Lines.Credit Lines.Discount Lines.TrackingCode Lines.ProposedAccountAmount Lines.CustomFields Lines.DiscountAmount Lines.MemberAccount Lines.BillableExpenseCustomer Lines.BillableExpenseSalesInvoice Lines.Invoice Contact BankClearDate BankClearStatus InventoryLocation AmountsIncludeTax CustomTheme Theme Type Reference AutomaticReference HasPaymentCustomTitle PaymentCustomTitle HasReceiptCustomTitle ReceiptCustomTitle Key
New format:
Receipts
Date Reference PaidBy Customer Supplier Contact ReceivedIn Status BankClearDate Description Lines.Item Lines.Account Lines.AccountsReceivableCustomer Lines.AccountsReceivableSalesInvoice Lines.BillableExpenseCustomer Lines.BillableExpenseSalesInvoice Lines.AccountsPayableSupplier Lines.PurchaseInvoice Lines.WithholdingTaxPayableSupplier Lines.Employee Lines.CapitalAccount Lines.SubAccount Lines.SpecialAccount Lines.FixedAsset Lines.IntangibleAsset Lines.ExpenseClaimsPayer Lines.Investment Lines.Description Lines.CustomFields Lines.Qty Lines.UnitPrice Lines.AutoUnitPrice Lines.Amount Lines.CurrencyAmount Lines.TotalBeforeTax Lines.TaxCode Lines.TaxAmount Lines.Total Lines.Project Lines.Division InventoryLocation LineDescription QuantityColumn UnitPriceColumn AmountsAreTaxExclusive FixedTotal FixedTotalAmount BalancingAmount CustomTheme ReceiptCustomTheme AutomaticReference CustomTitle ReceiptCustomTitle Key
Payments
Date Reference PaidFrom Status BankClearDate Payee Customer Supplier Contact Description Lines.Item Lines.Account Lines.AccountsReceivableCustomer Lines.AccountsReceivableSalesInvoice Lines.BillableExpenseCustomer Lines.BillableExpenseSalesInvoice Lines.AccountsPayableSupplier Lines.PurchaseInvoice Lines.WithholdingTaxPayableSupplier Lines.Employee Lines.CapitalAccount Lines.SubAccount Lines.SpecialAccount Lines.FixedAsset Lines.IntangibleAsset Lines.ExpenseClaimsPayer Lines.Investment Lines.Description Lines.CustomFields Lines.Qty Lines.UnitPrice Lines.AutoUnitPrice Lines.Amount Lines.CurrencyAmount Lines.TotalBeforeTax Lines.TaxCode Lines.TaxAmount Lines.Total Lines.Project Lines.Division InventoryLocation LineDescription QuantityColumn UnitPriceColumn AmountsAreTaxExclusive FixedTotal FixedTotalAmount BalancingAmount CustomTheme PaymentCustomTheme AutomaticReference CustomTitle PaymentCustomTitle Key
In the ‘old format’ the field ‘Type’ distinguished between a receipt or payment. In the ‘new format’ this field is entirely vanished and new field have been added.
Question
Is there any way I can simple use the old technique? If not any thoughts how I could simplify my CSV struggle? The fields from the N26 CSV are complex (Date, Payee, Account number, Transaction type, Payment reference, Category, Amount (EUR), Amount (Foreign Currency), Type Foreign Currency, Exchange Rate) but needs to be converted to a understandable Manager.io format for both receipts and payments. Perhaps a CSV to MT940 converter?
Thanks a lot,
Canefield