+ Reply to Thread
Results 1 to 9 of 9
  1. #1
    Join Date
    Mar 2007
    Posts
    8,496
    Thanks
    791
    Thanked
    837
    Reviews
    5
    Achievements:Topaz Star - 500 postsAmber Star - 2,000 postsAmethyst Star - 5,000 posts

    Default Question to accountants, book keepers, small business owners

    My DH works for himself, he owns his own truck/business. Every 3 months I have to do his BAS. Im wondering if there is an easier way. This is how I do it ATM:
    - At the end of the 3 months I print out the business bank statement (usually monthly so it doesn't seem too much)
    - I type in an Excel spreadsheet how much he earned and spent then calculate GST for each item.
    - Send it to Accountant for end of financial year tax

    Can I use a program that takes it directly from the bank statements as soon as it is purchased or do i have to automatically type it in? Purchases range from Insurance, Citylink to Fuel etc

  2. #2
    Join Date
    Jun 2010
    Posts
    859
    Thanks
    64
    Thanked
    224
    Reviews
    5
    Achievements:Topaz Star - 500 posts

    Default Question to accountants, book keepers, small business owners

    I'm with ANZ and the online banking has an option to export the transactions to a .csv file which can be opened in excel.

    Otherwise an accounting package like MYOB, Quickbooks or xero (which is online) can be used

  3. #3
    Join Date
    Mar 2007
    Posts
    8,496
    Thanks
    791
    Thanked
    837
    Reviews
    5
    Achievements:Topaz Star - 500 postsAmber Star - 2,000 postsAmethyst Star - 5,000 posts

    Default Question to accountants, book keepers, small business owners

    Quote Originally Posted by happygrl View Post
    I'm with ANZ and the online banking has an option to export the transactions to a .csv file which can be opened in excel.

    Otherwise an accounting package like MYOB, Quickbooks or xero (which is online) can be used
    I'm with Anz too! Is it easy to set up?

  4. #4
    Join Date
    Jun 2010
    Posts
    859
    Thanks
    64
    Thanked
    224
    Reviews
    5
    Achievements:Topaz Star - 500 posts

    Default Question to accountants, book keepers, small business owners

    Do you have Internet banking? I'm pretty sure you can just select export when you are looking at the transaction history of your account and select .csv.

    I'm on my phone ATM so I can't check but I'll have a look in the morning

  5. #5
    Join Date
    Mar 2007
    Posts
    8,496
    Thanks
    791
    Thanked
    837
    Reviews
    5
    Achievements:Topaz Star - 500 postsAmber Star - 2,000 postsAmethyst Star - 5,000 posts

    Default Question to accountants, book keepers, small business owners

    Thanks heaps!

  6. #6
    Join Date
    Jun 2010
    Posts
    859
    Thanks
    64
    Thanked
    224
    Reviews
    5
    Achievements:Topaz Star - 500 posts
    I've just had a look and if you go into your account transactions in the internet banking and click on the Download Transaction History link just above the right hand balance column it will take you to a screen where you can choose the account, timeframe and software package. Select Microsoft Excel and click download. You can only do the last 120 days, so it would be a good habit to start to do this monthly. That way you can also keep an eye on the transactions and make sure there are no bank errors

    Should save you some time

  7. #7
    Join Date
    Jan 2012
    Posts
    1,083
    Thanks
    123
    Thanked
    403
    Reviews
    0
    Achievements:Topaz Star - 500 posts

    Default Question to accountants, book keepers, small business owners

    How does he invoice out to be paid?

    It may be worth investing in a MYOB program or something similar.

  8. #8
    Join Date
    Mar 2007
    Posts
    8,496
    Thanks
    791
    Thanked
    837
    Reviews
    5
    Achievements:Topaz Star - 500 postsAmber Star - 2,000 postsAmethyst Star - 5,000 posts

    Default Question to accountants, book keepers, small business owners

    Quote Originally Posted by happygrl View Post
    I've just had a look and if you go into your account transactions in the internet banking and click on the Download Transaction History link just above the right hand balance column it will take you to a screen where you can choose the account, timeframe and software package. Select Microsoft Excel and click download. You can only do the last 120 days, so it would be a good habit to start to do this monthly. That way you can also keep an eye on the transactions and make sure there are no bank errors

    Should save you some time
    Thanks heaps

  9. #9
    Join Date
    Sep 2006
    Posts
    10,801
    Thanks
    1,338
    Thanked
    335
    Reviews
    0
    Achievements:Topaz Star - 500 postsAmber Star - 2,000 postsAmethyst Star - 5,000 postsEmerald Star - 10,000 posts

    Default Question to accountants, book keepers, small business owners

    There's a great web-based accounting system that beats MYOB hands down.
    It will reconcile all your bank accounts too.

    It's called Xero - just google it.

    On their website they have a list of accounts who use it too, as it's even more convenient if your account uses it too.


 

Similar Threads

  1. Business owners
    By BlueLips in forum Setting up & succeeding
    Replies: 12
    Last Post: 16-08-2012, 16:54
  2. Those who run a small business
    By Ffrenchknickers in forum General Chat
    Replies: 6
    Last Post: 15-08-2012, 14:12
  3. Small business startup help
    By Sunar11 in forum Setting up & succeeding
    Replies: 1
    Last Post: 28-03-2012, 00:07

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
FEATURED SUPPORTER
Edge Early LearningEdge Early Learning is Qld’s newest network of community based early learning centres. With unique environments that ...
FORUMS - chatting now ...
The Handmaids Tale Season 2Movies / Music / Books / TV Chat
How would you handle thisGeneral Parenting Tips, Advice & Chat
Child savings accIssues with Family Members
Organ donation error (sensitive)News & Current Affairs
High Natural Killer Cells #11Reproductive Immunology
Jolly Joyful JuneConception & Fertility General Chat
I am...#22General Chat
REVIEWS
"Made bed time less anxious"
by Meld85
My Little Heart Whisbear - the Humming Bear reviews ›
"Wonderful natural Aussie made product!"
by Mrstwr
Baby U Goat Milk Moisturiser reviews ›
"Replaced good quality with cheap tight nappies"
by Kris
Coles Comfy Bots Nappies reviews ›