Xero - tips and tricks

[Pheasant Surprise]

Really?! Transactions seem to have imported here recently....

I *think* its affecting some but not necessarily all HSBC accounts...Murphy's law

"HSBC (Direct Feed)
We’re still waiting to receive some of the bank feed files for HSBC statements dated 15th September 2019. We’re working with the bank to get these through to you."

I've got a support case logged with them.

 

[Pheasant Surprise]

Really?! Transactions seem to have imported here recently....

Txns all came through this morning

 

[legin]

Can anyone help please? Sent some Barley off got got remittance back with tonnage and price. How do I load on to Xero less the weighbridge charges & levies. Hope that makes sense.

 

[Jerry]

Can anyone help please? Sent some Barley off got got remittance back with tonnage and price. How do I load on to Xero less the weighbridge charges & levies. Hope that makes sense.

Input the first line of the sales invoice as the gross sale, then a new line on same invoice for the charges and levies etc, but put these in as negative values.

You then will see the net value to tie in with the payment to you.

 

[legin]

Brilliant. Works. Thank you

 

[atlas]

Just a quick question about reconciling .I paid a cheque in came back problem with signature so have a payment of £360 going in and then £360 coming back out so how do I sort it to reconcile it just delete those 2 lines as no transaction has taken place really or do I need to do something else .

 

[chickens and wheat]

If it shows in bank statement, then just reconcile the in and the out, they will cancel each other, one as Plus one as minus same category

 

[Boysground]

Just a quick question about reconciling .I paid a cheque in came back problem with signature so have a payment of £360 going in and then £360 coming back out so how do I sort it to reconcile it just delete those 2 lines as no transaction has taken place really or do I need to do something else .

Things like that I often write error in in the reference box so I can see quickly what it is or you can add a note to the individual transaction.

Bg

 

[britt]

Yes I wish cheques are banned! The hassle to go and bank them and then if they don't clear you have to go again.

Sorted now thank you.

Put cheques in an envelope with the paying slip and post it to the bank. I've not been to the bank in 20 years.

 

[Timbo]

Put cheques in an envelope with the paying slip and post it to the bank. I've not been to the bank in 20 years.

Can also pay them in at post office (but will take another 2 days to clear on top )

 

[Dairyfarmerswife]

Put cheques in an envelope with the paying slip and post it to the bank. I've not been to the bank in 20 years.

We have done this for years too, and only had one go missing, only to turn up the day after I had obtained a replacement! BUT we recently discovered that we can bank cheques and cash into our Natwest account at the local post office, so that's worth looking into too - only a five minute car drive and a regular haunt for us versus special trip into town.

 

[Dairyfarmerswife]

Can also pay them in at post office (but will take another 2 days to clear on top )

Cross post! Cash clears straight away, haven't tried a cheque but the two days wouldn't be more than it takes to post a cheque and for it to be received at the bank anyway.

 

[Pheasant Surprise]

You can also photograph your cheques and pay them in using your smartphone banking app. Different per cheque and daily pay in limits may apply depending on whom you bank with.

 

[Mark C]

When using xero or any other accounts really do you keep separate nominal codes for products bought in to sell as opposed to home grown?

EG I have a hay and straw purchases nominal code but shoud I have a hay and straw home grown nominal code too?

cheers

Mark

 

[stewart]

Just a quick question about reconciling .I paid a cheque in came back problem with signature so have a payment of £360 going in and then £360 coming back out so how do I sort it to reconcile it just delete those 2 lines as no transaction has taken place really or do I need to do something else .

But both in suspense account, one will balance the other out.

 

[Jerry]

When using xero or any other accounts really do you keep separate nominal codes for products bought in to sell as opposed to home grown?

EG I have a hay and straw purchases nominal code but shoud I have a hay and straw home grown nominal code too?

cheers

Mark

I tend to have separate codes as it helps transparency so you can better see where you are making money

 

[tepapa]

Is there a way to break up invoices into labour and materials? Currently it's just a long list of items without any clear definition of what's what.
Thinking I could add it into the description but would prefer separate sections.

 

[atlas]

Is there a way to break up invoices into labour and materials? Currently it's just a long list of items without any clear definition of what's what.
Thinking I could add it into the description but would prefer separate sections.

JUst add new lines into the invoice for each item you want to separate out.

 

[tepapa]

JUst add new lines into the invoice for each item you want to separate out.

I do that already, so I might have 10 different lines for labour and then 20 for materials. To the customer it's just a long list. I'd like to break it down into two definite sections so they know which lines correspond to which.

 

[farmerm]

Input the first line of the sales invoice as the gross sale, then a new line on same invoice for the charges and levies etc, but put these in as negative values.

You then will see the net value to tie in with the payment to you.

Does that work in xero? Does it apply VAT correctly too? I use Pandle not xero, I can't put in a negative value in a Pandle invoice or assign a line on a sales invoice to a costs category …

Only solution I have found for Pandle is to export the bank feed, and use excel to manual split all bank transactions that involve a self bill component into separate sales and cost transactions before I import them. I can then reconcile these against separate client and customer invoices. Its a bit of a faff and prone to human error though