|
|
|
De indeling van het outputbestand is conform de specificaties die te vinden zijn op de website https://support.quickbooks.intuit.com/support/pages/executable/iif/iif_import_kit.zip.
Daarnaast is een voorbeeld gebruikt dat door ISC is aangeleverd. Daarin staan de volgende boekingen:
!TRNS TRNSID TRNSTYPE DATE ACCNT CLASS AMOUNT DOCNUM MEMO
!SPL SPLID TRNSTYPE DATE ACCNT CLASS AMOUNT DOCNUM MEMO
!ENDTRNS
TRNS GENERAL JOURNAL 08/02/2017 CASH:RBC - Current Acc 961.25
SPL GENERAL JOURNAL 08/02/2017 OTHER RECEIVABLES:Mortgage Late Fee due -120.75
SPL GENERAL JOURNAL 08/02/2017 SALES:Mortgage:penalty -356.37
SPL GENERAL JOURNAL 08/02/2017 Mortgage Insurances:Insurances -398.78
SPL GENERAL JOURNAL 08/02/2017 INVESTMENTS & DEFERRED CHARGES:PFTSA MORTGAGES:Mortgage Principle (redemption) -85.35
SPL GENERAL JOURNAL 08/03/2017 CASH:RBC - Current Acc 6851.38
SPL GENERAL JOURNAL 08/03/2017 OTHER RECEIVABLES:Mortgage Late Fee due -425.46
SPL GENERAL JOURNAL 08/03/2017 SALES:Mortgage:penalty -2930.19
SPL GENERAL JOURNAL 08/03/2017 Mortgage Insurances:Insurances -1330.36
SPL GENERAL JOURNAL 08/03/2017 SALES:Mortgage:other -706.81
SPL GENERAL JOURNAL 08/03/2017 INVESTMENTS & DEFERRED CHARGES:PFTSA MORTGAGES:Mortgage Advanced Payments -1970.71
SPL GENERAL JOURNAL 08/03/2017 Mortgage Insurances:Insurance Payables 512.15
SPL GENERAL JOURNAL 08/07/2017 CASH:RBC - Current Acc 1965.47
SPL GENERAL JOURNAL 08/07/2017 SALES:Mortgage:other -98.02
SPL GENERAL JOURNAL 08/07/2017 INVESTMENTS & DEFERRED CHARGES:PFTSA MORTGAGES:Mortgage Advanced Payments -1867.45
SPL GENERAL JOURNAL 08/08/2017 CASH:RBC - Current Acc 3311.30
SPL GENERAL JOURNAL 08/08/2017 OTHER RECEIVABLES:Mortgage Late Fee due -310.70
SPL GENERAL JOURNAL 08/08/2017 SALES:Mortgage:penalty -2642.02
SPL GENERAL JOURNAL 08/08/2017 Mortgage Insurances:Insurances -868.97
SPL GENERAL JOURNAL 08/08/2017 SALES:Mortgage:other 95.48
SPL GENERAL JOURNAL 08/08/2017 INVESTMENTS & DEFERRED CHARGES:PFTSA MORTGAGES:Mortgage Advanced Payments 496.92
SPL GENERAL JOURNAL 08/08/2017 Mortgage Insurances:Insurance Payables -82.01
SPL GENERAL JOURNAL 08/10/2017 CASH:RBC - Current Acc 3327.83
SPL GENERAL JOURNAL 08/10/2017 OTHER RECEIVABLES:Mortgage Late Fee due -201.25
SPL GENERAL JOURNAL 08/10/2017 SALES:Mortgage:penalty -696.58
SPL GENERAL JOURNAL 08/10/2017 Mortgage Insurances:Insurances -714.51
SPL GENERAL JOURNAL 08/10/2017 INVESTMENTS & DEFERRED CHARGES:PFTSA MORTGAGES:Mortgage Principle (redemption) -931.58
SPL GENERAL JOURNAL 08/10/2017 INVESTMENTS & DEFERRED CHARGES:PFTSA MORTGAGES:Mortgage Advanced Payments -296.02
SPL GENERAL JOURNAL 08/10/2017 Mortgage Insurances:Insurance Payables -487.89
SPL GENERAL JOURNAL 08/11/2017 CASH:RBC - Current Acc 1391.64
SPL GENERAL JOURNAL 08/11/2017 OTHER RECEIVABLES:Mortgage Late Fee due -418.09
SPL GENERAL JOURNAL 08/11/2017 SALES:Mortgage:penalty -1751.82
SPL GENERAL JOURNAL 08/11/2017 Mortgage Insurances:Insurances -960.22
SPL GENERAL JOURNAL 08/11/2017 SALES:Mortgage:other 0.00
SPL GENERAL JOURNAL 08/11/2017 INVESTMENTS & DEFERRED CHARGES:PFTSA MORTGAGES:Mortgage Advanced Payments 862.29
SPL GENERAL JOURNAL 08/11/2017 Mortgage Insurances:Insurance Payables 876.20
SPL GENERAL JOURNAL 08/17/2017 CASH:RBC - Current Acc 7708.46
SPL GENERAL JOURNAL 08/17/2017 INVESTMENTS & DEFERRED CHARGES:PFTSA MORTGAGES:Mortgage Principle (redemption) -814.04
SPL GENERAL JOURNAL 08/17/2017 SALES:Mortgage:other -238.55
SPL GENERAL JOURNAL 08/17/2017 INVESTMENTS & DEFERRED CHARGES:PFTSA MORTGAGES:Mortgage Advanced Payments -2563.91
SPL GENERAL JOURNAL 08/17/2017 Mortgage Insurances:Insurance Payables -4091.96
SPL GENERAL JOURNAL 08/23/2017 CASH:RBC - Current Acc 2592.77
SPL GENERAL JOURNAL 08/23/2017 OTHER RECEIVABLES:Mortgage Late Fee due -361.01
SPL GENERAL JOURNAL 08/23/2017 SALES:Mortgage:penalty -1429.66
SPL GENERAL JOURNAL 08/23/2017 Mortgage Insurances:Insurances -870.08
SPL GENERAL JOURNAL 08/23/2017 INVESTMENTS & DEFERRED CHARGES:PFTSA MORTGAGES:Mortgage Principle (redemption) -21.70
SPL GENERAL JOURNAL 08/23/2017 SALES:Mortgage:other -95.48
SPL GENERAL JOURNAL 08/23/2017 INVESTMENTS & DEFERRED CHARGES:PFTSA MORTGAGES:Mortgage Advanced Payments 500.47
SPL GENERAL JOURNAL 08/23/2017 Mortgage Insurances:Insurance Payables -315.31
SPL GENERAL JOURNAL 08/24/2017 CASH:RBC - Current Acc 842.41
SPL GENERAL JOURNAL 08/24/2017 OTHER RECEIVABLES:Mortgage Late Fee due -107.21
SPL GENERAL JOURNAL 08/24/2017 SALES:Mortgage:penalty -1189.39
SPL GENERAL JOURNAL 08/24/2017 Mortgage Insurances:Insurances -352.72
SPL GENERAL JOURNAL 08/24/2017 SALES:Mortgage:other 0.00
SPL GENERAL JOURNAL 08/24/2017 INVESTMENTS & DEFERRED CHARGES:PFTSA MORTGAGES:Mortgage Advanced Payments 454.19
SPL GENERAL JOURNAL 08/24/2017 Mortgage Insurances:Insurance Payables 352.72
SPL GENERAL JOURNAL 08/25/2017 CASH:RBC - Current Acc 2010.23
SPL GENERAL JOURNAL 08/25/2017 INVESTMENTS & DEFERRED CHARGES:PFTSA MORTGAGES:Mortgage Principle (redemption) -374.53
SPL GENERAL JOURNAL 08/25/2017 INVESTMENTS & DEFERRED CHARGES:PFTSA MORTGAGES:Mortgage Advanced Payments -904.66
SPL GENERAL JOURNAL 08/25/2017 Mortgage Insurances:Insurance Payables -731.04
ENDTRNS