Docstoc

Journal Entry Voucher Format Excel

Document Sample
Journal Entry Voucher Format Excel Powered By Docstoc
					                                                                 Journal Entry Form

Transaction Date                                     4/30/2007                                               Document #      100001634

Fiscal Mo./ Yr.                                       Apr-07

Company Code:                US 212
Currency:                    USD

                                           Text                                       Account #     CC#           Debit          Credit

Salaries                     SALARY PAID - OCTOBER 2011                                500000     US 23231         233,222
Bank Account # 1             SALARY PAID - OCTOBER 2011                                111100                                      233,222




                                                                                                  TOTAL:           233,222         233,222

Comments to appear in document header
(No greater than 15 characters)



Purpose:




Prepared by:                 Accountant                                                                      Approved by:
                                                                 Journal Entry Form

Transaction Date                                    10/24/2011                                                 Document #       100004723

Fiscal Mo./ Yr.                                       Oct-11

Company Code:                US 212
Currency:                    USD

                                          Text                                        Account #      CC#            Debit           Credit

Office Rent                  OFFICE RENT M/O OCT11 - OWNER NAME                        500012     US 2121022       230,000.00
Prepaid facilities rent      OFFICE RENT M/O OCT11 - OWNER NAME                        134001                                      230,000.00




                                                                                                   TOTAL:          230,000.00      230,000.00

Comments to appear in document header
(No greater than 15 characters)



Purpose:




Prepared by:                 Accountant                                                                        Approved by:
                                                                 Journal Entry Form

Transaction Date                                    10/27/2011                                                 Document #       10004828

Fiscal Mo./ Yr.                                       Oct-11

Company Code:                US 212
Currency:                    USD

                                          Text                                        Account #      CC#            Debit        Credit

Bank Charges                 FED BANK CHARGES-SCB                                      500049     US 2121019            34.33
Bank Account # 2             FED BANK CHARGES-SCB                                      111101                                        34.33




                                                                                                   TOTAL:               34.33        34.33

Comments to appear in document header
(No greater than 15 characters)



Purpose:


FED BANK CHARGES-SCB




Prepared by:                 Accountant                                                                        Approved by:
                                                                  Journal Entry Form

Transaction Date                                     10/24/2011                                                 Document #       100004717

Fiscal Mo./ Yr.                                        Oct-11

Company Code:                US 212
Currency:                    USD

                                           Text                                        Account #      CC#            Debit           Credit

Medical insurance expense    LIFE INSURANCE EXP M/O OCT08-NJI                           500005     US 2129338        10,400.00
Prepaid insurance            LIFE INSURANCE EXP M/O OCT08-NJI                           137000                                       10,400.00




                                                                                                    TOTAL:           10,400.00       10,400.00

Comments to appear in document header
(No greater than 15 characters)



Purpose:




Prepared by:                 Accountant                                                                         Approved by:
                                                                Journal Entry Form

Transaction Date                                   12/27/2011                                                 Document #       100002617

Fiscal Mo./ Yr.                                     Dec-11

Company Code:                US 212
Currency:                    USD

                                          Text                                       Account #      CC#            Debit           Credit

Hardware/software support    SERVER SUPPORT-NOV-DEC11-EXCELLENT                       500037     US 2121204        14,602.00
Prepaid maintenance          SERVER SUPPORT-NOV-DEC11-EXCELLENT                       133000                                       14,602.00




                                                                                                  TOTAL:           14,602.00       14,602.00

Comments to appear in document header
(No greater than 15 characters)



Purpose:

PREP SUPRT VARITAS




Prepared by:                 Accountant                                                                       Approved by:
ENTER YOUR CHART OF ACCOUNTS HERE

ACC #     Name of Account
 100000   Cash in Hand
 101000   Cash Clearing
 102000   Cheque Clearing
 111100   Bank Account # 1
 111101   Bank Account # 2
 111102   Bank Account # 3
 120000   Advance Income Tax
 131000   Advances to Employees
 132000   Short Term Deposits
 133000   Prepaid maintenance
 134001   Prepaid facilities rent
 135002   Prepaid telecommunications
 136003   Prepaid leases
 137000   Prepaid insurance
 138003   Advances to Vendors
 140000   Inter Company Receivables
 191000   Lease improvements
 192000   Computer equipment
 193000   Engineering equip
 194000   Demo/trng equipment
 195000   Commun equip
 195600   Computer software
 197600   Laptop computers
 198600   Desktop PC's
 199000   Office furniture
 200000   Office equipment
 210000   Vehicles
 220000   Capital leases
 230000   Operating leases
 300000   Acc amort leaseholds
 301000   Acc depn comp equip
 302000   Acc depn engr equip
 303000   Acc depn demo equip
 304000   Acc depn comm equip
 305000   Acc dep computer SW
 306000   Accum Dep - Laptops
 307000   Acc depn dsktp PC's
 308000   Acc dep network eqp
 309000   Acc depn office furn
 310000   Acc depn office equp
 311000   Acc depn vehicles
 312000   Acc dep network eqp
 313000   Acc dep capital leas
 350000   Facility Deposit LT
 351000   Other deposits LT
 352000   Trade payables
 353000   Accrued Actual Inv.
 354000   Accr salaries/wages
 355000   Accr vacation payable
336000   Accr bonus payable
337000   Accr social contribs
338008   Emp taxes withheld
339008   Accr aud/legal/cons
340000   Accr telecomm
341000   Accr insurance pay
342000   Withholding tax services 6%
343000   Withholding tax services 3.5%
344000   Other Liabs - LT
400000   Share Capital Accounts
410000   Retd earnings begin
500000   Salaries
500001   Vacation pay
500002   Sick leave
500003   Overtime pay
500004   Cash bonuses
500005   Medical insurance expense
500006   Lunch vouchers
500007   Employee activities
500008   Employee relocation
500009   Travel
500010   Meals
500011   Daily allowances
500012   Office Rent
500013   Company cars - fuel & mtc
500014   Temporary help
500015   Consulting
500016   Legal fees
500017   Audit/tax accounting
500018   Other prof. services
500019   Company car insurance & taxes
500020   Advertising
500021   Web advertising
500022   Mktg communications
500023   Collateral/brochures
500024   Telecommunications
500025   Local phone service
500026   Long distance phone
500027   Data communications
500028   Cellular & pager use
500029   Postage/courier
500030   Supplies
500031   Office equipment
500032   Communications equip
500033   Equip repair & maint
500034   Company car lease
500035   Dues/subscriptions
500036   External training
500037   Hardware/software support
500038   Facilities lease
500039   Utilities
500040   Janitorial
500041   Property taxes
500042   Freight
500043   General insurance
500044   Company car taxes
500045   Discounts taken
500046   Bad debt
500047   Intercompa X charges
500048   Miscellaneous
500049   Bank Charges
500050   Realized FX gain
500051   Realized FX loss
600000   Local Sales
600001   Export Sales
600002   Other Income
600003   Deferred Income

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:5332
posted:12/7/2011
language:English
pages:8
Description: Journal Entry Voucher Format Excel uses VLOOKUP to automatically populate account name from your chart of accounts. Enjoy!