Tuesday 7, 2006

0132381877 Managing Business Expense Reports With Microsoft Excel

Keeping track of your business receipts should be mandatory and not optional. Your employee should understand the importance of this and realize how this may impact the accuracy of their report if the receipts are not present. Lost receipts can be retrieved by contacting the vendor to get a copy. The employee should realize that this is their responsibility especially if they expect reimbursement for those types of expenses.

Your standardized business expense report should have different areas to account for your employee expenses. There should be an area of general ledger accounts numbers, general ledger account names, date and location of expenses, and if necessary mileage calculations. This information will greatly assist your accounting team when they reconcile the expenses!

Lastly, your business expense reports should be submitted on a set timed schedule. It should be encouraged to submit them weekly or monthly. This should be mandatory and not optional. The goal is to reconcile for expenses in a timely manner so they company can see where their funds are being spent and if they are being used responsibly. To get employees on board with this, try incentive based rewards in the first few months to get them used the new timed schedule.

Excel templates are an excellent tool to use when you are standardizing your business expense report. Most companies already have Office or a similar product loaded on their company computers so using templates can assist in this standardization process. Below is an example of an excel business expense report. This expense report contains a sheet that allows you enter up to 30 general ledger accounts names and numbers. It also contains a weekly business expense report area that allows you to select the appropriate general ledger account and detail the expense prior to printing.

Article Source: http://www.articlesbase.com/accounting-articles/managing-business-expense-reports-with-microsoft-excel-1340285.html

About the Author

Get your own expense report template by visiting our huge template gallery free free excel templates today!


Small Biz Buzz
  • Cisco WAP2000 Wireless-G Access Point – POE
  • Managing Google PPC In A Small Business – Account Set Up
  • What Are The Most Important Questions To Ask Of Small Business Accounting Software
  • Accounting Software Selection Advice
  • Small Business Accounting Troubles Gets Solved With Accounting Software!


8 Responses

  • dante.seth@y7mail.com says:

    i have job interview?
    and i don’t know if my resume is any good for an accounting job and what do i wear as i want to get this great job. if u can help let me know

    this is my resume
    Profile
    My career objective is to secure part time or temp employment in an administrative and finance role working for a busy business in the Toowoomba region. I’m currently enrolled in a diploma of accounting at TAFE and I have 4 years experience in administration/office duties as well as experience with MYOB.
    Personal Attributes
    §Excellent customer service and people skills, able to build rapport quickly with others
    §Self motivated worker who works well in a team environment
    §Excellent organisational skills and ability to pay attention to details
    §Able to follow instructions and work unsupervised as required
    §Mature, dependable, reliable with a strong work ethic
    §Current ‘C’ Class Driver’s Licence

    Education, Qualifications and Training
    Current Diploma of accounting at TAFE. I also am enrolled in MYOB, Tax and Law.
    2008Certificate IV in Financial Services (Accounting)
    Business Success Group, Toowoomba
    2003Graduated Year 10
    Centenary Heights State High School, Toowoomba
    Computer Skills
    Excellent keyboard skills, competent in most programs including Microsoft Office, MYOB, Quicken, the Internet and email. Typing speed 55wpm at 96% accuracy.

    Work Experience
    2008Casual Bookkeeper and Receptionist
    ABC Bookkeeping, Toowoomba
    Responsibilities
    §General front desk reception and administrative support for a small bookkeeping company. Also assisted with the actual bookkeeping tasks which included data entry into MYOB, Quicken and Excel.
    2007Assistant Manager
    to 2008Issabella’s Passion Fashion Store, Toowoomba
    Responsibilities
    §General retail store management duties including stock control, merchandising, customer service, sales, accounts payable and receivable, bookkeeping, payroll and all staff related duties such as training and rostering.
    2003Front of House Duties
    to 2006Café Rest Point, Clifford Gardens, Toowoomba
    Responsibilities
    §General hospitality duties including barista operations, customer service, cash handling, food preparation and hygiene and other duties as required.

    • Ed Atun says:

      The resume is complete and “to the point”. It should be fine. Wear clothes that you feel comfortable in. Do not buy new clothes for an interview. You can reward yourself with new clothes with your first paycheck if you get the job.
      Pretend that you are an actor in a movie about someone who is applying for a job. You are trying to get the Academy Award for acting..

  • wellnesscoach says:

    whether yahoo Uk & Ireland hold lotteries as mentioned?
    Yahoo!My Yahoo!Mail Make Y! your home pageYahoo! SearchSearch:Welcome, soms999
    [Sign Out, My Account]Mail Home -Mail Tutorials -Help

    Mail | Addresses | Calendar | Notepad Yahoo! on Mobile – Upgrades – Options Check MailCompose Search MailSearch the Web

    A card in 3 days

    for bad credit*

    Folders[Add - Edit]
    Inbox (695) Draft Sent Bulk (17)[Empty] Trash[Empty] My Folders[Hide]
    soms999
    Search Shortcuts
    My Photos My Attachments

    See your

    credit score: $0

    No Form Filling

    Just Upload CV

    Watch Videos

    On Yahoo! Music

    Upload your CV

    Get a dream Job
    You can receive a SMS text alert when this person sends you Mail.
    Please register for mail alerts to activate this service.

    Previous | Next | Back to Messages Call or Instant Message lotto_office_2
    DeleteReplyForwardSpamMove…
    Printable View This message is not flagged. [ Flag Message - Mark as Unread ]

    Date: Mon, 23 Oct 2006 07:08:16 -0700 (PDT)
    From: “DERBY lotto INTERNATIONAL INTERNATIONAL” View Contact Details Add Mobile Alert
    Yahoo! DomainKeys has confirmed that this message was sent by yahoo.com. Learn more
    Subject: CONGRATULATION, YOU HAVE WON THE YAHOO LOTTERY OF THE MONTH.
    To: soms...@yahoo.com

    Yahoo Lottery
    Incoperation
    Baley House, Har Road
    Sutton, Greater London
    SM1 4te,
    United Kingdom
    +447031817810

    This is to inform you that you have won a prize money of THREE HUNDRED THOUSAND US DOLLARS ($300,000) for the YEAR 2006 Lottery promotion which is organized by YAHOO LOTTERY INC & WINDOWS LIVE.

    YAHOO & MICROSOFT WINDOWS, collects all the email addresses of the people that are active online, among the millions that subscribed to Yahoo and Hotmail we only select five people every YEAR as our winners through electronic balloting System without the winner applying,we congratulate you for being one of the people selected.

    PAYMENT OF PRIZE AND CLAIM

    You are to contact your Claims Agent on or before your date of Claim, Winners Shall be paid in accordance with his/her Settlement Centre.
    Yahoo Lottery Prize must be claimed no later than 7 days from date of Draw Notification after the Draw date in which Prize has won. Any prize not claimed within this period will be forfeited.

    These are your identification numbers:
    Batch number…………………YM 09102XN
    Reff number………………….YM35447XN
    Winning number……………….YM09788

    These numbers above fall within the African agent’s Location file, you are requested to contact him and send your winning identification numbers to him,
    OKOH DAVID at his email:

    PHONE: +23408026563192
    E-mail: okoh...@yahoo.com

    You are therefore advise to send the following information to the Claim Agent to facilitate them and process the transfer of your fund.

    1. Full name………………
    2. Country………………..
    3. Contact Address…………
    4. Telephone Number………..
    5. Marital Status………….
    6. Occupation……………..
    7. Age……………………
    8. Sex……………………

    Congratulations!! once again.
    Yours in service,

    MRS ROSE DAVID

    ——————————————————————————–
    Want to be your own boss? Learn how on Yahoo! Small Business.
    The HTML graphics in this message have been displayed. [Edit Preferences - What's This?]

    DeleteReplyForwardSpamMove…
    Previous | Next | Back to Messages Save Message Text | Full Headers
    Check MailCompose Search MailSearch the Web

    Move Options
    [New Folder]
    soms999
    Forward Options
    As Inline Text
    As Attachment
    Reply Options
    Reply To Sender
    Reply To Everyone
    Mail Shortcuts
    Check Mail Ctrl++C
    Compose Ctrl++P
    Folders Ctrl++F
    Advanced Search Ctrl++S
    Options
    Help Ctrl++H
    Address Book Shortcuts
    Add Contact
    Add Category
    View Contacts
    View Lists
    Quickbuilder
    Import Contacts
    Synchronize
    Addresses Options
    Addresses Help
    Calendar Shortcuts
    Add Event
    Add Task
    Add Birthday
    Day
    Week
    Month
    Year
    Event List
    Reminders
    Tasks
    Sharing
    Synchronize
    Calendar Options
    Calendar Help
    Notepad Shortcuts
    Add Note
    Add Folder
    View Notes
    Notepad Options
    Notepad Help
    Advanced Search
    Advanced Search

    Copyright © 1994-2006 Yahoo! Inc. All rights reserved. Terms of Service – Copyright/IP Policy – Guidelines – Ad Feedback
    NOTICE: We collect personal information on this site.
    To learn more about how we use your information, see our Privacy Policy

  • wellnesscoach says:

    whether yahoo! UK & Ireland hold the lotttery as mentioned?
    Yahoo!My Yahoo!Mail Make Y! your home pageYahoo! SearchSearch:Welcome, soms999
    [Sign Out, My Account]Mail Home -Mail Tutorials -Help

    Mail | Addresses | Calendar | Notepad Yahoo! on Mobile – Upgrades – Options Check MailCompose Search MailSearch the Web

    A card in 3 days

    for bad credit*

    Folders[Add - Edit]
    Inbox (695) Draft Sent Bulk (17)[Empty] Trash[Empty] My Folders[Hide]
    soms999
    Search Shortcuts
    My Photos My Attachments

    See your

    credit score: $0

    No Form Filling

    Just Upload CV

    Watch Videos

    On Yahoo! Music

    Upload your CV

    Get a dream Job
    You can receive a SMS text alert when this person sends you Mail.
    Please register for mail alerts to activate this service.

    Previous | Next | Back to Messages Call or Instant Message lotto_office_2
    DeleteReplyForwardSpamMove…
    Printable View This message is not flagged. [ Flag Message - Mark as Unread ]

    Date: Mon, 23 Oct 2006 07:08:16 -0700 (PDT)
    From: “DERBY lotto INTERNATIONAL INTERNATIONAL” View Contact Details Add Mobile Alert
    Yahoo! DomainKeys has confirmed that this message was sent by yahoo.com. Learn more
    Subject: CONGRATULATION, YOU HAVE WON THE YAHOO LOTTERY OF THE MONTH.
    To: soms...@yahoo.com

    Yahoo Lottery
    Incoperation
    Baley House, Har Road
    Sutton, Greater London
    SM1 4te,
    United Kingdom
    +447031817810

    This is to inform you that you have won a prize money of THREE HUNDRED THOUSAND US DOLLARS ($300,000) for the YEAR 2006 Lottery promotion which is organized by YAHOO LOTTERY INC & WINDOWS LIVE.

    YAHOO & MICROSOFT WINDOWS, collects all the email addresses of the people that are active online, among the millions that subscribed to Yahoo and Hotmail we only select five people every YEAR as our winners through electronic balloting System without the winner applying,we congratulate you for being one of the people selected.

    PAYMENT OF PRIZE AND CLAIM

    You are to contact your Claims Agent on or before your date of Claim, Winners Shall be paid in accordance with his/her Settlement Centre.
    Yahoo Lottery Prize must be claimed no later than 7 days from date of Draw Notification after the Draw date in which Prize has won. Any prize not claimed within this period will be forfeited.

    These are your identification numbers:
    Batch number…………………YM 09102XN
    Reff number………………….YM35447XN
    Winning number……………….YM09788

    These numbers above fall within the African agent’s Location file, you are requested to contact him and send your winning identification numbers to him,
    OKOH DAVID at his email:

    PHONE: +23408026563192
    E-mail: okoh...@yahoo.com

    You are therefore advise to send the following information to the Claim Agent to facilitate them and process the transfer of your fund.

    1. Full name………………
    2. Country………………..
    3. Contact Address…………
    4. Telephone Number………..
    5. Marital Status………….
    6. Occupation……………..
    7. Age……………………
    8. Sex……………………

    Congratulations!! once again.
    Yours in service,

    MRS ROSE DAVID

    ——————————————————————————–
    Want to be your own boss? Learn how on Yahoo! Small Business.
    The HTML graphics in this message have been displayed. [Edit Preferences - What's This?]

    DeleteReplyForwardSpamMove…
    Previous | Next | Back to Messages Save Message Text | Full Headers
    Check MailCompose Search MailSearch the Web

    Move Options
    [New Folder]
    soms999
    Forward Options
    As Inline Text
    As Attachment
    Reply Options
    Reply To Sender
    Reply To Everyone
    Mail Shortcuts
    Check Mail Ctrl++C
    Compose Ctrl++P
    Folders Ctrl++F
    Advanced Search Ctrl++S
    Options
    Help Ctrl++H
    Address Book Shortcuts
    Add Contact
    Add Category
    View Contacts
    View Lists
    Quickbuilder
    Import Contacts
    Synchronize
    Addresses Options
    Addresses Help
    Calendar Shortcuts
    Add Event
    Add Task
    Add Birthday
    Day
    Week
    Month
    Year
    Event List
    Reminders
    Tasks
    Sharing
    Synchronize
    Calendar Options
    Calendar Help
    Notepad Shortcuts
    Add Note
    Add Folder
    View Notes
    Notepad Options
    Notepad Help
    Advanced Search
    Advanced Search

    Copyright © 1994-2006 Yahoo! Inc. All rights reserved. Terms of Service – Copyright/IP Policy – Guidelines – Ad Feedback
    NOTICE: We collect personal information on this site.
    To learn more about how we use your information, see our Privacy Policy

  • Sugarcutie says:

    How do you know what jobs to apply for?
    With this Experience & Training —- what could i apply for?

    20010 Bachelor of Arts – Psychology
    Lakehead University, ON

    2008-2009 Student Work Op Green Team
    Cowichan Campus Green Committee Student Member
    Vancouver Island University, BC, Canada

    2007 Freelance Photographer
    Ste Anne De Bellevue, QC
    Taking and selling photos in small town

    2007 Independent Sales Representative
    SMC Corporation , Online

    2006 Sandwich Maker
    Quiznos Subs, DDO, Quebec
    Customer service and clean-up

    2006 Technical Writer & Editor
    McGill University- Department of Bio-Engineering, Montreal QC
    Edited texts in DOC and PDF formats, both on hard disk and on cdrom
    Edited graduate students’ papers in Geology and Bio-Engineering

    2006 Teach English as a Foreign Language
    Norwood English Institute, Ireland

    2005 Community Online Development Certificate, BC, Canada
    Connecting communities worldwide
    Insurance Brokers Association of B.C

    2003-2005 Independent Sales Representative
    Excel Telecommunications Canada & Herbalife Canada
    2002-2006 Online Business Owner
    Books & CDs Second Hand Sales
    Sold books and cd’s through online websites

    2002 Animal Welfare Certificate, BC, Canada
    Office procedures and financial basics, Animal Care
    Thompson Rivers University

    2002-2003 Girl Guide Leader
    Created Animal Care Badge, Campfire SingSong Program
    Girl Guides Of Canada, Victoria, BC

    2002 Teacher Assistant, Short Term Volunteer Position
    BC School of Ideal Education, Victoria, BC

    1999 High School Diploma & Peer Helper Certificate
    Queen Margaret’s School, Duncan, BC

    1999 Teacher Assistant – Junior Music & Band
    Queen Margarets School, Duncan, BC

    1995-1997 Teacher Assistant – Junior Stage Band
    2nd Tenor Saxophone In Senior Jazz Ensemble
    Centennial Academy, Montreal, QC

    Computer Skills

    PC Basic Skills Certified- NCSA
    Windows XP Professional Certified- NCSA

    Medical Terminology & Computerized Transcription
    QBasic and DOS & Shell Programming
    Microsoft Office 95-2007, Windows 95-7,
    Quicken (Quickbooks), Simply Accounting.

    Work and Character References available upon request.



Leave a Reply