Services Limited
Integrated Business Solutions
|
|
Services Limited |
Integrated Business Solutions |
|
|---|---|---|---|
| CREDITORS REPORTS |
See reports for general information and running. There are also Sales Reports related to Creditors.
These report and printout samples follow through one of three invoices for a single creditor.
Each Invoice OR Batch of Invoices and Import of Costings from Suppliers has a Batch No. e.g.
1364
Text (e.g. "DISK") replaces GL a/c name (e.g. "PURCHASES") if overwritten.
Creditor Ref. Date Due Order Dept.Br. Tr. Per. Batch Tx.
Expense TOTAL Value GST Disc. % Qty. Product Dept.
Batch Header 20/07/2009 15 1364
COGITO Cogito Services Ltd 3912 30/06/2009 20/07/2009 SALE 1 15 1364 I 0000000
316000 DISK 50.00 44.44 5.56 I 1.00 SALE
316000 PURCHASES 85.00 75.56 9.44 I 1.00 SALE
Document Totals 135.00 120.00 15.00 2.00
** Run Totals ** Docs. = 1 135.00 120.00 15.00
This was run for a single creditor's unprocessed invoices.
Once processed, the Run No.s also print (see below e.g. 148).
The Status is "space" for Entered (not Updated) invoices (otherwise Processed / Cancelled).
Any duplications detected are reported.
Br. to Runs to 9999
Suppliers COG to COGzzzzz Conf.
Supp. Invoice Date Due Tax Value Per. By St. Run Creditor
------------------------------------------------------------------------------------------------------------------------------------
COGITO 3912 30/06/09 20/07/09 15.00 135.00 15 JS Cogito Services Ltd
3985 30/06/09 20/07/09 129.11 1,162.00 15 JS Cogito Services Ltd
3987 30/06/09 20/07/09 99.67 897.00 15 JS Cogito Services Ltd
Sub-total 2,194.00
------------------------------------------------------------------------------------------------------------------------------------
*** Run Totals *** Due Tax Value Per. By St. Run Cre
Confirmed Invoices 243.78 2,194.00
------------------------------------------------------------------------------------------------------------------------------------
Details reports on GL account and the GST exclusive amount posted to it.
Supp. Invoice Date Due Tax Value Per. By St. Run Creditor
------------------------------------------------------------------------------------------------------------------------------------
COGITO 300000 15.00 120.00 Software
3912 30/06/09 20/07/09 15.00 135.00 15 JS Cogito Services Ltd
300000 129.11 1,032.89 Software
3985 30/06/09 20/07/09 129.11 1,162.00 15 JS Cogito Services Ltd
300000 99.67 797.33 Software
3987 30/06/09 20/07/09 99.67 897.00 15 JS Cogito Services Ltd
Sub-total 2,194.00
------------------------------------------------------------------------------------------------------------------------------------
Each update has a GL Batch No. e.g. CR0148 that is attached to the Ledger
postings (you will find these references in GL Transaction Lookup). It is also the Creditors
Update Run No.
N.B. The Batch Totals (Debit / Credit) should match.
Seq Tp P Date Account Ref Qty Debit Credit Name
00010 A 15 13/07/09 CR0148
00020 P 15 30/06/09 316000 3912 44.44 Computer Consumables
0000000000 COGITO DISK
00030 P 15 30/06/09 316000 3912 75.56 Computer Consumables
0000000000 COGITO PURCHASES
00040 P 15 30/06/09 270001 3985 779.56 Purchases
0000000000 COGITO PURCHASES
00050 P 15 30/06/09 270003 3985 253.33 Purchases
0000000000 COGITO 3985 Cogito Services Ltd
00060 P 15 30/06/09 281000 3987 797.33 Consulting Fees
0000000000 COGITO 3987 Cogito Services Ltd
00070 P 15 13/07/09 870000 SIL22 2,194.00 Accounts Payable
0000000000 From Creditors Update
00080 P 15 13/07/09 911000 SIL22 243.78 GST - Expenses
0000000000 From Creditors Update
BATCH TOTALS 2,194.00 2,194.00
N.B. Batch Totals should match.
End of Month Current Period
CRRC Opening Balance 29,534.74 30,930.28
CRTT01 Purchase 2,194.00 37,082.19
CRTT03 Payment 36,287.73-
Total Posted 2,194.00 794.46
Closing Balance 31,728.74 31,724.74
--------------------------------------------------------------------------------
*** GST SUMMARY *** End of Month Current Period
Base GST Base GST
CRTX01 1,950.22 243.78 12,886.03 1,610.79
CRTX09 Nontaxable 22,585.37
** Total GST ** 1,950.22 243.78 35,471.40 1,610.79
Base + Tax..... 2,1946.00 37,082.19
Total Due Not Due
31,728.74 15,558.73 16,170.01
Control = Trial Balance (8CRP04BS Trial Balance Summary can follow Control Report.)
Run for a single creditor - Unpaid transactions
Trial Balance - Detail All
Account Name DUE Current 1 Mth 2 Mths 3 Mths Future TOTAL Purch YTD Last Pmt
COGITO Cogito Services Ltd 2194.00 2,194.00 2,194 00/00
3912 30/06/09 N Purchase 135.00
3985 30/06/09 N Purchase 1162.00
3987 30/06/09 N Purchase 897.00
Sub total 2194.00 2,194.00 2,194
Trial Balance - O/Seas - 4x Foreign currency
Account Name DUE Current 1 Mth 2+ Mths Next Mth Future TOTAL Purch YTD Last Pmt
Currency AUD Australian $
MENTIS Mentis Technologies Pty. Ltd 2211.03 2,211.03 2,690 05/00
100 18/09/09 N Purchase 1435.53
1258 21/09/09 N Purchase 380.00
654 20/09/09 N Purchase 395.50
Sub total AUD Australian $ 2211.03 2,211.03 2,690
Currency GBP Pounds Sterling
CAMP Campbell Software Ltd 348.92 348.92 348.92 1,016 09/00
1558 21/09/09 N Purchase 135.11
54 21/09/09 N Purchase 213.81
Sub total GBP Pounds Sterling 348.92 348.92 348.92 1,016
Trial Balance - O/Seas - Local (NZ) currency
Account Name DUE Current 1 Mth 2+ Mths Next Mth Future TOTAL Purch YTD Last Pmt
Currency AUD Australian $
MENTIS Mentis Technologies Pty. Ltd 2690.00 2,690.00 2,690 05/00
100 18/09/09 N Purchase 1740.00
1258 21/09/09 N Purchase 475.00
654 20/09/09 N Purchase 475.00
Sub total AUD Australian $ 2690.00 2,690.00 2,690
Currency GBP Pounds Sterling
CAMP Campbell Software Ltd 1,016.18 1016.18 1,016.18 1,016 09/00
1558 21/09/09 N Purchase 393.50
54 21/09/09 N Purchase 622.68
Sub total GBP Pounds Sterling 1,016.18 1016.18 1,016.18 1,016
Account Date Reference Type --Date--DUE--Value-- Not Due Held Paid Disc.
COGITO Cogito Services Ltd 2,194.00
Sub total 2,194.00
There are several layouts - including line-flow, A4 paper and PDF for e-mailing - cheque printing may include remittance advice.
R E M I T T A N C E A D V I C E
COGITO Services Ltd
81 Champion St Phone (03) 980-0280
PO Box 25071 Fax (03) 980-6558
Cogito Services Ltd
PO Box 25071
81 Champion St
Victoria
Christchurch
Account COGITO Fax 980-6558 13/07/2006 Page 1
jill@cogito.co.nz
---------------------------------------------------------
Date Transaction Reference Debit Credit
---------------------------------------------------------
30/06/06 Purchase 3912 135.00
30/06/06 Purchase 3985 1,162.00
30/06/06 Purchase 3987 897.00
Up to 4 lines of text may included with 8CRP04R1 / R2.
A standing message OR a one off message - OR both
* TOTAL * 2,194.00
Tp Batch Date Paid by Dept. Operator.
Account Name Ref. Chq. Value
10 A 03 P Payment 4 13/07/09 Supervisor
20 P COGITO Cogito Services Ltd 100488 2,194.00
Invoice 3912 135.00
Invoice 3985 1,162.00
Invoice 3987 897.00
30 X TOTAL: 2,194.00
Followed by a
End of Month Current Period
CRRC Opening Balance 31,724.74 30,930.28
CRTT01 Purchase 37,082.19
CRTT03 Payment 2,194.00- 38,481.73-
Total Posted 2,194.00- 1,395.54
Closing Balance 29,530.74 29,530.74
--------------------------------------------------------------------------------
*** GST SUMMARY *** End of Month Current Period
Base GST Base GST
CRTX01 12,886.03 1,610.79
CRTX09 Nontaxable 22,585.37
** Total GST ** 35,471.40 1,610.79
Layouts differ - Remittance Advice optional
100488 1
Purchase 30/06/09 3912 135.00 135.00
Purchase 30/06/09 3985 1,162.00 1,162.00
Purchase 30/06/09 3987 897.00 897.00
Cheque Enclosed 2,194.00
100488 13/07/2009
** TWO THOUSAND ONE HUNDRED AND NINETY-FOUR **
*****************DOLLARS ONLY***************** ******2,194.00
Cogito Services Ltd
P O Box 25-071
390 Montreal St
Victoria
Christchurch
Account Date Per. Batch Update Ref. Type St. Credit Debit TOTAL
COGITO 13/07/2009 15 4 149 0000100488 3 P P 2,194.00 Cogito Services Ltd
20/07/2009 15 1362 148 3985 1 I P 1,162.00 Purchases - Stationery
20/07/2009 15 1363 148 3987 1 I P 897.00 Consulting Fees
20/07/2009 15 1364 148 3912 1 I P 135.00 N.WORK CARD
*** Run Totals *** 2,194.00 2,194.00 .00
There are also export versions directed to ccCRPX.CSV
8CRP01EX
* Format: ASCII, Comma-delimited, Quotes
* Output: Acc, Due date, Seq, Trans Code, Trans Type,
* Status, Ref, Inv date, Value, Inv Disc, Tax, Batch no.,
* Cheque No., Cheque date, Cheque run no.,
* Payment method, Update date, Update run no.,
* Value orig, PL Update sw, PL period,
* Currency code, Currency rate, Value 4x, Text,
* Payment value, Matched
8CRP01E1
* Format: ASCII, Comma-delimited, Quotes
* Output: Account,Ref,Order,Receipt,Inv date,
* value,Costed,Ck,Posted,due,nett,GST,
* Per,TT,St,text
8CRP01ES
* Format: ASCII, Comma-delimited, Quotes
* Output: Acc, Per, Due, Inv date, Value, Paid on,
* Paid, TT, St, Ref, Batch, Cheque, Paid,
* Proc, Run, Orig, Text
Date Reference Type Due Tax Total
Ledger code value
COGI Cogito Services Ltd 243.78 2,194.00
30/06/09 3912 Purchase 20/07/09 15.00 135.00
00 00 3 16000 DISK 44.44
00 00 3 16000 PURCHASES 75.56
30/06/09 3985 Purchase 20/07/09 129.11 1,162.00
00 00 2 70001 PURCHASES 779.56
00 00 2 70003 PURCHASES 253.33
30/06/09 3987 Purchase 20/07/09 99.67 897.00
00 00 2 81000 Consulting Fees 797.33
Sub total 243.78 2,194.00
Name Postal Address 3. Town
Account Name Phone Fax Address
COGI Cogito Services Ltd 03-980-0280 03-980-6558 PO Box 25071, 81 Champion St, Edgeware, Christchurch 8013
Mr M Schroeder MS J Schroeder I
8CRP04E2 - NAME AND ADDRESS EXPORT
* Format: ASCII, Comma-delimited, Quotes
* Output: Code, 1st 6 characters of Name, Name, Address 1 - 3, Type
8CRP04E8 - NAME AND PHONE CONTACTS EXPORT
* Creditors File Export for CogFax / Callista
* Format: ASCII, Comma-delimited, Quotes
* Output: Name, Phone, Fax, Contact 2, Acct.
* Format: ASCII, Comma-delimited, Quotes * Output: Code, Status, Name 8CRP04EX - CRM EXPORT * Format: ASCII, Comma-delimited * Output: Account, Check, related, status, rep, type, name, postal, street, suburb, town, PostCode, area, region, Message,Phone, Fax, WebSite, Promo, Inv when, Inv Prt, Inv Eml, Qt when, Qt Prt, Qt Eml, Stmt when, Stmt Prt, Stmt Eml,SALES called-1, name-1, job-1, e-mail-1, cell-1, promo-1, ADMIN called-2, name-2, job-2, e-mail-2, cell-2, promo-2, PARTS called-3, name-3, job-3, e-mail-3, cell-3, promo-3, OTHER called-4, name-4, job-4, e-mail-4, cell-4, promo-4,OTHER called-5, Name-5, Job-5, E-mail-5, Cell-5, Promo-5, OTHER called-6, Name-6, Job-6, E-mail-6, Cell-6, Promo-6, Group-1, group-2, group-3, group-4 8CRP04EB - DIRECT CREDIT EXPORT * Format: ASCII, Comma-delimited * Output: Code,Type,Bank A/c,Our Ref,Their Ref,Paid By,Accounts e-mail,name, called,Orders e-mail,name,called,name,