is it possible to import existing spreadsheets (in excel) & use them with this software?
is it possible to import existing spreadsheets (in excel) & use them with this software?
-
cara.key
February 20, 2016
*fingers crossed here!!!*
1 answer
Ha ha,
Well the good news is it’s my Birthday tomorrow. The bad news is no. Accounts products “manipulate data”, like pushing it through a sieve so you can import exported data.
We also ask for information that keeps you compliant, most spreadsheets don’t.
The whole idea of the product being free is to free people from spreadsheets. 🙂
Sorry
-
Tell me a little about your business and what you're looking to do and I'll tell you what the min is you need to do to get on Bullet.
-
a recruitment company; bank recs, invoice tracking etc. have a nice existing invoice template to keep. currently track all bills owed & those with/without VAT by spreadsheet so need to keep that too
-
was recommended xero but its old & crappy...... like reinventing the wheel and couldnt use existing invoice template (with yours it accepted headers etc straight away so YAY!), bank account imports etc
-
back in 20 mins (school run)
-
Boom your back.
-
I've some Q's.
Are you a sole trader or limited company? -
a company
-
Ok so you've done your year end just past?
-
nope; new company last started last april; year end will be end of march
-
Ok, and you're not registered for vat?
-
we are reg for VAT
-
some of our clients are internationally placed = no VAT; some are domestically placed = VAT applicable
-
we do VAT 3 returns etc
-
Cool. Ok so the best thing to do is the following, you can keep all your old spreadsheets etc so they don't really matter to Bullet (and are usually wrong - cheeky)
Take a bank rec from when you started the business. (your bank must match your accounts Rev look at the accounts).
Enter in a total invoice for each client to bring them up to day. As in if you do recruitment for AIB and have sent them 10 invoices that are paid and one that is outstanding just create one invoice for all the paid ones (totals are fine).
You can add your payroll runs too
Bullet will automatically start generating your P30's and VAT3's you can just mark them as paid (if you've paid them).
That's really it. Start with the bank account. Ignore your spreadsheets.
Pete -
excellent news...... finally acc software that doesnt reinvent the wheel! what format do the existing files (bank statements, invoices, payroll runs) need to be in to work? Excel/word/adobe requirements etc?
-
this now means I can get this set up this weekend and get ahead of next VAT return & prepared for end of year
-
I don't understand the file formats, everything is done in Bullet. it does everything.
Your bank will give you an export file, if not pick "other", from our dropdown list and we'll give you a spreadsheet that's already formatted you can just copy and paste your banks website into that.
We automate all the VAT3/P35/P30s returns, so they'll be done automatically.
We also update all your management reports in the backend too. It's Xero but with a bit layer of workflows sitting on top of it.
Pete -
ok thanks for all your help Pete; much appreciated!
-
Keep it real. Have a good weekend. Up the Kingdom.
-
LOL cheers!!
