×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How much time do you spend on bookkeeping?

How much time do you spend on bookkeeping?

How much time do you spend on bookkeeping?

(OP)
I do a small amount of consulting work on the weekends and evenings. It's about $5k a year or so.

I took a class in Financial Accounting as part of a graduate degree program last summer, and it made me think a little about bookkeeping. In a matter of a couple hours, I created the basic chart of accounts in Excel.

Then I got to thinking about using software like QuickBooks or Peachtree to formalize the books. Do many people here use computer accounting software? I picked up a free copy of Peachtree and found that it will take some time to sit down and learn. I'd rather spend my time engineering or having fun that learning accounting! But if it brought good benefits in the end, it'd be something I was willing to.

What do you do for your books and how much time do you spend on them?

Cedar Bluff Engineering
http://cedarbluffengineering.webs.com

RE: How much time do you spend on bookkeeping?

Excel file.

one page to track invoices.  column for I#, date, customer, hours, expenses, invoiced amount, calculated date to expect payment, payment status
one page per year for bank account with columns for each 1120S entry.  Insurance, taxes, medical rembersment, office expens, etc, invoice deposits
one page that takes data from the above and calculates taxes and compensation (with profit sharing IRA deductions).
one page that has yearly summary (profit/loss)

I still submit info to CPA to allow him to verify, but he was impressed with the iterration loop I have that calcs employer/employee taxes.  I print the above and file with 1120s each year.


customer invoicing (time sheet) is done with seperate Excel file that calcs with hours, rates plus expenses.  this Excel file is changed per use.  the excel invoice is then "printed" as a PDF and emailed to Customers Financial Office.

The amount of time I spend is mainly filling out the invoice and making sure I have no errors in it.  Then entering into the main file.  If there is any time spent on book keeping, it is like last week doing a little to compensation calc sheet to see how many hours I need to meet self set goal for this year.


so far this has work for about 3 years now for me

RE: How much time do you spend on bookkeeping?

I do the books for my husband's consulting, and just use an Excel spreadsheet.  For income of about $100,000, it takes me about 2 hrs/mon. Of course, we first set up an invoice template, an expense template and the spreadsheet with formulas, so all I need to do now is input invoice info.

Here in our 5 person office, we use BillQuick for tracking time; it can also be used to generate invoices and has quite a few useful reports.  But for actual bookkeeping, we still use Quickbooks.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Resources

Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Design for Additive Manufacturing (DfAM)
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close