Transcription
10 BOOKKEEPING FORMS AND TEMPLATESTable of ContentsPART ONE – 10 Printable Forms and Templates . 2PART TWO – Completed Examples of the 10 Forms and Templates . 14PART THREE – Information Guide on Using the 10 Forms and Templates . 28Single Entry Bookkeeping – Using a Cashbook . 29Bank Reconciliation Statements . 32Delivery Docket Template . 35Free Sales Invoice Template . 37Statement of Account. 41Petty Cash Log. 44Profit and Loss Statement . 47Bookkeeping Journals. 49Bookkeeping Ledgers . 54Home Office Tax Expenses . 58Share It, Follow Us, Like Us . 62Copyright Details . 63Copyright 2016 Beginner Bookkeeping All rights reserved1
10 BOOKKEEPING FORMS AND TEMPLATESPART ONEPRINTABLEForms and TemplatesI recommend that you print off this document so that you canlay the blank forms and templates side by side with the completedexamples and the information pages. This will make it easier to followalong with how they work.I hope you enjoy learning how these bookkeeping forms andtemplates are used in a business setting, and that your confidencegrows!Contact me if you have any questions or comments.RegardsSarah BooysenCopyright 2016 Beginner Bookkeeping All rights reserved2
Month:CASHBOOKDetailsDateDescriptionBusiness / Name:Money InRefMoney OutTotalOutTotal InTotalsCopyright 2016 Beginner Bookkeeping All rights reserved3BankBalance
BANK RECONCILIATION REPORTBusiness Name:Date of Bank Statement:Bank Account:Outstanding WithdrawalsDateDetailAmountOutstanding DepositsDateTotal ADetailAmountTotal BReconciliationClosing Cash Book BalanceAdd: Outstanding Withdrawals (Total A)Sub-totalLess: Outstanding Deposits (Total B)Expected Bank Statement BalanceCopyright 2016 Beginner Bookkeeping All rights reserved4
DELIVERY DOCKETDate:Docket No:Delivery to:Supplied by:Customer PO#:Tel No:Reference:Order Date:Delivery rPlease retain this delivery docket as proof of purchase.Comments:Copyright 2016 Beginner Bookkeeping All rights reserved5
SALES INVOICEDate:Invoice No:To:From:QuantityDescriptionUnit PriceCostSubtotalComment:DiscountPayment due by:TaxPay to Bank Account No:Interest ofTotal Dueper annum will be charged on late payments.Cut here RemittanceCustomer NameInvoice No.Amount PaidCopyright 2016 Beginner Bookkeeping All rights reserved6
STATEMENT OF ACCOUNTTo:From:Reference:Date:DateNo.Opening Balance:AmountPayment RemainingDescriptionSubtotalInterestCommentPayment due by:Total DuePlease make payment into Bank Account No.:Interest of% per annum will be charged on late payments.Cut Here RemittanceCustomerReferenceCopyright 2016 Beginner Bookkeeping All rights reservedInvoices PaidTotal Paid7
PETTY CASH LOGMONTH:DATEVOUCHERNUMBERDETAILSCASH INCASHOUTBALANCETOTAL CASH LEFTFLOAT:LESS TOTAL CASH LEFT TOPUPAMOUNTCopyright 2016 Beginner Bookkeeping All rights reserved8
-------PETTY CASH VOUCHERDate:Cash Out:Detail:Cash In:Total:Voucher ----------PETTY CASH VOUCHERDate:Cash Out:Detail:Cash In:Total:Voucher ----------PETTY CASH VOUCHERDate:Cash Out:Detail:Cash In:Total:Voucher ----------PETTY CASH VOUCHERDate:Cash Out:Detail:Cash In:Total:Voucher ----------Copyright 2016 Beginner Bookkeeping All rights reserved9
PROFIT AND LOSS REPORTINCOMEAmountDescription(example – Sales, Service Income, Inventory Income)AmountTotal IncomeCOST OF GOODS SOLDAmountDescription(example – Materials, Subcontractor, Inventory)AmountTotal Cost of SalesAmountGross Profit(Total Income Less Total Cost of Sales)EXPENSESDescriptionAmount(example – Advertising, Stationery, Postage, Gas)AmountTotal ExpensesAmountNet Profit/(Loss)(Gross Profit Less Total Expenses)Copyright 2016 Beginner Bookkeeping All rights reserved10
GENERAL JOURNALDateDescriptionDebit (Dr)Copyright 2016 Beginner Bookkeeping All rights reservedCredit (Cr)11Ref
GENERAL onCopyright 2016 Beginner Bookkeeping All rights reservedRefCredit12
HOME OFFICE )Interest onMortgageRentCity Rates/TaxesHome &ContentsInsuranceRepairs tal PaidGrand TotalPercentageEnter the percentage of your home that is exclusively used as the business officeTOTAL CLAIMCopyright 2016 Beginner Bookkeeping All rights reserved13Total PerMonth
10 BOOKKEEPING FORMS AND TEMPLATESPART TWOCOMPLETED EXAMPLESForms and TemplatesCopyright 2016 Beginner Bookkeeping All rights reserved14
Month: August 2016CASHBOOK EXAMPLEDetailsMoney OutMoney Aug-19Aug-21Aug-24Aug-27Aug-29Aug-30Aug-30Balance b/fPetty cash floatFolders and pensMs E Inkson Inv031Mr R U Redy Inv032DrawingsEnvelopes & StampsWeb host feesSimply Chairs: ChairMr J Mighty Inv033Ms T Real – I034Bank FeeCashEftDCDCEftEftDD0001DCCashFeeTotalsBusiness / Name: My 0.0054.00168.0010.0035.0040.00Copyright 2016 Beginner Bookkeeping All rights 3.50100.0018.2230.00TotalOutRRRRRRRRR
BANK RECONCILIATION REPORT EXAMPLEBusiness Name:My BusinessDate of Bank Statement:August 31st, 2016Bank Account:Current AccountOutstanding WithdrawalsDateAug 27 007DetailAmount127.00Total AOutstanding DepositsDateAug 30127.00DetailAmount54.00Total B54.00ReconciliationClosing Cash Book Balance 153.50Add: Outstanding Withdrawals (Total A) 127.00Sub-total 280.50Less: Outstanding Deposits (Total B)Expected Bank Statement BalanceCopyright 2016 Beginner Bookkeeping All rights reserved 54.00 226.5016
DELIVERY DOCKET EXAMPLE09.04.16Date:Docket No:Delivery to:DD15Supplied by:Small Store Inc.At my addressAt this address5 Any StreetIn this townAny CityAt this area codeThis Area CodeCustomer PO#: PO5032Order Date:Delivery Date:September 3, 201612456789Tel No:Reference:September 4, ats252009.04.16T-Shirts Size M353509.04.16T-Shirts Size L353509.04.16Shorts Size L3520Backorder515Please retain this delivery docket as proof of purchase.Comments:Backorders expected delivery date 20.09.16Copyright 2016 Beginner Bookkeeping All rights reserved17
SALES INVOICE EXAMPLESeptember, 14 2016Date:I035Invoice No:To:From:Small Store Inc.My BusinessAt this address5 Any StreetIn this townAny CityAt this area codeThis Area CodeQuantityDescriptionUnit PriceCost20Hats 4.00 80.0035T-Shirts Size M 5.00 175.0035T-Shirts Size L 5.00 175.0020Shorts Size L 7.00 140.00Comment: Your PO#5032Ref our Delivery Docket DD15 09.04.16Payment due by: October 30, 2016Pay to Bank Account No:12345678910Interest ofSubtotal570.00Discount0.00Tax0.00Total Due 570.0010 % per annum will be charged on late payments.Cut here RemittanceMy BusinessSmall Store Inc.5 Any StreetCustomer NameAny CityInvoice No.This Area CodeI035Amount PaidCopyright 2016 Beginner Bookkeeping All rights reserved18
STATEMENT OF ACCOUNT EXAMPLETo:From:Small Store Inc.My BusinessAt this address5 Any StreetIn this townAny CityAt this area codeThis Area CodeReference:Date:September 30, 2016DateNo. 400.00Opening Balance:AmountPayment RemainingDescription09.14.16I035Sale 570.00 970.0009.18.16I042Sale 320.00 1,290.0009.30.16CommentPaymentPlease pay your overdue amount of 100.00within 7 daysPayment due by:October 31, 2016Please make payment into Bank Account No.: 300.00 990.00SubtotalInterest 990.00Total Due 992.74 2.7412345678910Interest of 10% per annum will be charged on late payments.Cut Here Small Store Inc.RemittanceCustomerInvoices PaidThe customer fills in theamount they are payingMy Business5 Any StreetI035Any CityI042This Area CodeReferenceCopyright 2016 Beginner Bookkeeping All rights reservedTotal Paid19
PETTY CASH LOG EXAMPLEMONTH:August 3Box of blue pensAug-084Aug-15DETAILSCASH und coffee7.0079.505Ream of printer paper9.0070.50Aug-196Croissants – Staff er payment: Inv027 (hats)Aug-229Jenny – office cleaner25.0039.50Aug-2310Print ink18.0021.50Aug-2411Parking3.0018.50TOTAL CASH LEFT18.50FLOAT: 100.00LESS TOTAL CASH LEFT12.50 18.50 TOPUPAMOUNT64.50 ------------Copyright 2016 Beginner Bookkeeping All rights reserved20
PETTY CASH VOUCHER EXAMPLEDate: August 1, 2016Cash Out:Detail: Float – cash from mainbank accountVoucher No:Cash In: 100.00Total: --------------PETTY CASH VOUCHER EXAMPLEDate: August 4, 2016Detail: MilkVoucher No:Cash Out: 5.00Cash In: 1.50Total: ------------PETTY CASH VOUCHER EXAMPLEDate: August 7, 2016Cash Out:Detail: Box of blue pensCash In:Total:Voucher No: 10.00 -------------PETTY CASH VOUCHER EXAMPLEDate: August 8, 2016Cash Out:Detail: Ground coffeeCash In:Total:Voucher No: 7.00 -------------Copyright 2016 Beginner Bookkeeping All rights reserved21
PROFIT AND LOSS REPORT EXAMPLEINCOMEAmountDescription(example – Sales, Service Income, Inventory Income)Sales Income – Hats108.94Sales Income - Tops71.56The income and expenses onthis report include totals fromboth the Cashbook and thePetty Cash Log added togetherAmount180.50Total IncomeCOST OF GOODS SOLDAmountDescription(example – Materials, Sub-Contractors, Inventory, Freight)Amount0.00Total Cost of SalesAmount180.50Gross Profit(Total Income Less Cost of Sales)EXPENSESDescriptionAmount(example – Advertising, Stationery, Postage, Fuel)Bank Fees2.50Cleaning25.00Kitchen29.00Office EquipmentParkingNote: Petty cash floatand Drawings go on theBalance 8.50Total ExpensesNet Profit/(Loss)Amount(118.00)(Gross Profit Less Expenses)Copyright 2016 Beginner Bookkeeping All rights reserved22
GENERAL JOURNAL EXAMPLE (Page 1)DateAugust 01DescriptionPetty CashDebit (Dr)Credit (Cr)Ref100.00Bank100.00Cash withdrawal for petty cash floatAugust 04J1Note: either the Ledger Number or a ‘P’for posted goes into the ‘Ref’ columnwhen the value is posted to the ledger.Stationery15.00Bank60115.00 001Folders & pens from Stationers Corp.paid with bank card (EFT)August 15Bank54.00001Sales Income – Hats18.22Sales Income – Tops35.78418Sale: Ms E Inkson paid by checkAugust 18Bank30.00Sales Income Hats00130.00418Sale: Mr R U Redy paid by directdepositAugust 19Drawings10.00Bank33010.00 001Owner’s private use of business fundspaid by bank card (EFT)August 21Stationery20.00Bank60120.00 001Envelopes & stamps from StationersCorp. paid with bank card (EFT)Copyright 2016 Beginner Bookkeeping All rights reserved23
GENERAL JOURNAL EXAMPLE (Page 2)DateAugust 24DescriptionWebhost ExpensesDebit (Dr)J2Credit (Cr)Ref40.00Bank40.00 001August webhost fee paid to WebhostInc. by Direct DebitAugust 27Office Equipment Expense127.00Bank127.00 001Office chair from Simply Chairspaid with Check 0001August 29Bank30.00Sales Income – Hats00130.00418Sale: Mr J Mighty paid by bankdepositAugust 30Bank fees2.50Bank2.50 001Monthly account chargeAugust 30Bank54.00001Sales Income – Hats18.22Sales Income – Tops35.78Sale: Ms T Real paid by cashCopyright 2016 Beginner Bookkeeping All rights reserved24418
GENERAL LEDGER EXAMPLE 1Account:DateDescription001BANKRefDebitDate300.00 Aug 01DescriptionRefCreditPetty CashJ1100.00August 2016Aug 1Opening balanceb/fAug 15Sales - HatsJ118.22 Aug 04StationeryJ115.00Sales - TopsJ135.78 Aug 19DrawingsJ110.00Aug 18Sales - HatsJ130.00 Aug 21StationeryJ120.00Aug 29Sales – HatsJ230.00 Aug 24Webhost Exp.J140.00Aug 30Sales – HatsJ218.22 Aug 27Office Equip.J2127.00Sales – TopsJ235.78 Aug 30Bank FeesJ22.50468.00314.50September 2016Sep 1Opening balanceb/f153.50GENERAL LEDGER EXAMPLE 2601Account: fCreditAugust 2016Aug 1Opening balanceb/f50.00Aug 4BankJ115.00Aug 21BankJ120.00Aug 7Petty CashJ310.00Aug 15Petty CashJ39.00Aug 25Petty CashJ318.00122.00Copyright 2016 Beginner Bookkeeping All rights reserved25
G
10 BOOKKEEPING FORMS AND TEMPLATES PART ONE PRINTABLE Forms and Templates I recommend that you print off this document so that you can lay the blank forms and templates side by side with the completed examples and the information pages. This will make it easier to follow along with how they work. I hope you enjoy learning how these bookkeeping forms and templates are used in a
