Open Purchase Order Report Shows PO's That Are Received In Full

In Quickbooks Pro Manufacturing Edition are you seeing Purchase Orders on your Open PO report in Quickbooks that have been received in full.  Are you seeing the “Received In Full” stamp on these PO’s when you open them to try to determine the cause of the error.

Here is a little trick that I have found works well for me.  Open the purchase order that is in question (be sure to keep track of the PO number), change the date of the PO to the year 2030 and save and close it.   Use the “Find” feature with the PO number or locate it in the Customer center if you no longer see it on the report.  Re-open the PO and change the date back to the correct year and save and close it.

Give this a try and please comment on whether or not it has fixed your problem.  It has worked well for me and I am curious to find out if others have the same result.  Yes, I admit, it’s just a treatment and doesn’t really diagnose why this is happening.

Am picking this mortgage, why?

 What exactly makes pick one mortgage loan package and leave the other? What attracts you to your favourite package? The fact is you’ll in all circumstances repay the loan amount plus interest to the lender regardless of the amount in question. Am sorry my learned fellows .In all posts in this blog my target is the common /ordinary person who needs to live, borrow and prosper just like others though they lack enough knowledge about the lending, credit and finance sectors.My language therefore is the simplest and friendly only to ensure that one get at least something for survival tomorrow.
 Back to the topic.When I talk about mortgage, it’s all about houses and owning a house.So, if you’ll be looking to own a house or building or buy a house for business or residential purpose ,what are you going to consider leaving out majority of the terms used in real estate?
 Whoever the lender might be , I have a collection of some of the preliminary characteristics of a favourable mortgage plan for a startup:

   1. Extent of financing.

How much is the lender ready to give in relation to the cost of the house or building? Majority of lenders will finance upto a given percentage for example 80% and cover the rest yourself.As for me I think 100% financing is better. Let there only be the pain of repaying the loan when it’s due.The thing is ,if you want a house let you see a house but not iron sheets, timber , sand and no bricks! This drives me to my second characteristic; real estate company involvement.

   2.Real Estate company involvement.

Real estate companies are the experts in matters concerning building houses with the right experience. The thing is these people will show you a house.what am I saying? Good mortgage givers enter into partnerships with real estate companies to give mortgage loans to their clients. Here , even the convincing power is high because the customer can view the real house on site. The advantage again is that you can right away start using the house for your residential or business purposes. Let there only be the pain of waiting for full ownership rights when the loan is fully settled. What will I do with a plot I would like to develop? Simple, let the lender develop it for you through a real estate company.

  3.Minimum Deposit.

The minimum deposit comes in when the loan can’t finance the cost of the building 100%. The percentage left (in reference to characteristic number 1, the minimum deposit will be 20%) is termed as the minimum deposit required for a borrower to qualify for that mortgage. A good mortgage should have a small or no minimum deposit altogether.

   4 . Insurance

Okay ,this is complex but it good to know. What will happen to you if the house you were loaned get consumed by fire or brought down by a hurricane? All the property used as collateral will be gone! Therefore, to avoid this , consider a mortgage package that has an insurance plan incorporated in it.The monthly premiums will save your collateral property.

    5.Duration of maturity.

When will the loan be fully repaid? Currently in Kenya, majority of lenders give upto 7 months ,that’s a duration of six years. This is the best duration for a good mortgage loan.Why? Because the amount of monthly instalments will be very low .Are you not happy paying just small amounts of money for a big mansion?

The above characteristics of a favourable mortgage loan are the main ones according to ‘Loans Kenya’. There are other factors too which apply to all loans .These are ; loan interest rate, secured or unsecured and valuation fees and stamp duty.

Lending finance soars to a 7 year high

Upbeat news
A compelling couple of days indeed for economic data releases, then.
First and foremost, the Labour Force figures showed that the Australian economy has added 234,000 jobs over the past year, as I analysed in a little more detail here.
When we get such strong results commentators tend to declare that they are “too good to be true” – the figures must be wrong – and this month was no exception, of course.
I haven’t gotten around to reading the market commentary on the April Lending Finance data yet (in truth, they don’t get all that much coverage in the media) but I imagine these must be too good to be true as well, since in the event April proved to be a massive result – one of the strongest ever.
Yesterday’s Lending Finance figures from the ABS showed that April was one the biggest months on record for lending in Australia.
On only two previous occasions have we seen more substantial lending data in an individual month.
You invariably get accused of hubris for pointing these things out, but what can you do? Them’s the numbers. 
Let’s take a look…
7 year high for lending
The April Lending Finance figures revealed a thumping $75.7 billion of lending in the month.
This was the strongest monthly result since waaaaay back in January 2008, and tantalisingly close to the all time record monthly lending figure which breached $78.4 billion back in June 2007.
The nature of this data series is that the monthly figures tend to jump around quite a bit, so I prefer to look at the figures on a rolling annual basis.
We already know that owner-occupier housing finance has increased in a robust manner, up by another 3.1 in April and by 9.3 per cent over the past year on a rolling annual basis, a typical and rational enough response to ultra-low mortgage rates.
Commercial finance increased by another 4 per cent in April and is now up by an even stronger 13.8 per cent on an equivalent rolling 12 monthly basis.
This takes rolling annual total lending finance 11.9 per cent higher over the past year.
Lower interest rates have clearly encouraged investors and homebuyers into the real estate markets, and businesses have evidently become more inclined towards borrowing and refinancing too.
Here’s the chart:

Investment pipeline weak

So what’s the downside, given that we’ve just had the third largest month of lending on record? 

The answer is that both capital expenditure plans and the investment pipeline are weak.

Total capital expenditure is broadly expected to fall by nearly 25 per cent from $149 billion in 2014-15 to just $104 billion in 2015-16.

This implies that the increase in commercial lending may well be on shaky ground if investment plans don’t pick up, which they may or may not.

I’ve always preferred looking to the “actuals” versus “expecteds” when it comes to capital expenditure and other ABS data.

This is largely because I know how perfunctory certain of my own submissions were back in my Group FC days, particularly on expected capex, which – let’s face it – is very much an art rather than a science.

Never missed a deadline, though!

Personal and other credit
Lease finance has increased sharply by 13.2 per cent over the past year.
While on the subject of credit, data released by the Reserve Bank of Australia revealed that the average credit card balance has declined by 1.2 per cent over the past year, and the average credit card limit declined by 0.4 per cent in April too.
This underscores the fact that with mortgage repayments having fallen to remarkably cheap levels, households are shoring up their finances and enjoying getting well ahead on mortgage repayments instead.

Average credit card repayments tumbled from $1,704 in March to $1,538 in April, and remarkably the proportion of credit card limits utilised has plummeted to its lowest level in 13 years.
Small wonder that mortgage arrears and loan impairments are also tracking close to their lowest level in years.

Property investor loans

On of the interesting sub-sets to this data series is the breakdown of property investor loans by state.

I’ve smoothed the data again below on a rolling annual basis.
I know people like to argue that theoretically interest rates don’t drive or impact property markets, but, hell’s bells, just look at the chart!
Presented in this manner, investor loans in New South Wales have exploded 32 per cent higher over the past year.
And in fact on a rolling annual basis property investment loans have increased almost everywhere, including in Victoria (+22 per cent), Queensland (+14 per cent), Western Australia (+10 per cent), South Australia (+11 per cent) and Tasmania (+23 per cent).

By contrast, the investor loan data has been pretty much stone dead flat in the Australian Capital and Northern Territories respectively on a rolling annualised basis. 
Original data
This data series is not seasonally adjusted, but looking at the unadjusted or “original” data series reveals some interesting trends.
Queensland investor lending is clearly now tracking materially higher than was the case through the 2011 and 2012 lull.
This is being reflected in rising median house prices in inner Brisbane suburbs such as New Farm, East Brisbane, Coorparoo, Norman Park, Woollooongabba, Holland Park, Newmarket, Wilston, Clayfield, and others.

South Australia is also steadily emerging as a destination for budding property investors, despite the weaknesses apparent in both the underlying economy and labour markets.

In Western Australia the up-trend is rather less convincing, despite a lift in total investor lending over the past year. In fact, it could be rolling over.

Meanwhile in New South Wales, the Sydney market in particular is burning up, with total investor lending over the past year in the state unprecedented at $61.1 billion.
As a point of comparison, just three years ago in the year to April 2012 the equivalent figure was just $26.5 billion.
Lending has more than doubled (and then some) over that time horizon.

Unfortunately as noted here previously Sydney property listings appear to have dipped sharply again in June.
In some suburbs there is almost no stock for sale at all!
It’s going to be a decmented third quarter for Sydney property markets in 2015. 
Finally, as for the droll reports that Sydney prices have been “falling” despite auction clearance rates ripping to record highs at close to 90 per cent…lol.

AAR Credit and Bright launched a loan package

 I know you are used to the famous AAR insurance company in Kenya which covers everybody against diverse calamities in life.Yes your are right but the company is growing. Apart from collecting premium which is the major source of benefits gained by insurers ,AAR developed a new limb, long enough and prepared to reach for ‘interest’ hence the origination of AAR Credit. But what is ‘Bright? I have talked much enough to give an clear overview about AAR Credit.Bright or Bright Technologies Limited is a fast growing tech company based in Nairobi Kenya specialising in selling digital gadgets.
 Then why did the two companies come together? What loan package came out of their partnership? Stop asking too many questions.The thing is AAR wanted to collect interest from its borrowers while Bright on the other hand wanted to get buyers for their goods.You know the objective of this blog ‘Loans Kenya’ is to inform borrowers of anything concerning loans or credit so that they can quickly take advantage of it.
 So, what does the package carry?Okay. This package covers everybody from salaried individuals to self employed to SMEs to corporates. Where do you belong?There are laptops, desktops, smartphones and more other gadgets all on credit.Thinking of starting a cybercafé or bring in computers in your corporate offices? A aah just mentioning some examples.
 How it works? Visit Bright Technologies premises in Nairobi at Ground floor, old mutual building, Kimathi street and ask for the loan application forms after choosing the item or items you wish to buy on credit. The filled in forms will be forwarded to AAR Credit for evaluation.
  What you need to know now?
1)The loan will cover 70% of the total value of the gadgets. Therefore, you must provide 30% as deposit.
2) The minimum loan amount is ksh15000
3) The loan will be repaid within a period of 1 2 months at an interest rate of 2.5% per month.
4) There’s a processing fee of 4% and 3.01% as premium for the gadget because it’s going to be insured.
5) As usual with lenders ,you’ll need to provide ID or Passport ,payslips ,PIN certificate for businesses/corporates, bank statements.
  The loan processing will be within one week. Disapproved loans will get applicants refunded their deposits.
  I have been advising people for some time now and what I know is that people fear much when so many documents get mentioned by the lenders.That should not get one afraid because some of them are in your reach.
  You are now updated!

Residential construction boom to continue

Jobs news today
Australia’s favoured share market index, the ASX 200 (“XJO”), continues to meander along, now miserably hovering below 5,500, having previously once again threatened 6,000.
It’s a monster day ahead for news with the Labour Force figures out at 11.30am.
After a somewhat downcast speech from Reserve Bank Governor Stevens yesterday, analysts will be awaiting these latest figures with bated breath.
Before we move on to look at the employment figures in detail, a quick look at why the residential construction boom has plenty of gas left in its tank yet.

New home finance up

The Housing Finance figures for April showed a moderate increase in the seasonally adjusted number of new dwelling commitments to 2,766 in the month.
While this was an improvement on the March figure, smoothing the data on a 4mMA basis, shows that the trend looks to have passed its peak.

In terms of the value of loans written for new dwellings, the data recorded a record high of $1.03 billion in April, reflective of the expensive nature of new housing stock in Australia.
Investors both domestically and from offshore pay a hefty premium to buy new, and this has taken rolling annual new dwellings finance its highest ever level at $11.6 billion.

Despite the trend in new dwelling commitments looking decidedly toppy, this overlooks that a sizeable percentage of new dwelling sales are made to foreign investors, particularly in Sydney, Melbourne, Brisbane, and elsewhere.
Naturally enough, these offshore sales are not picked up in our domestic housing finance figures.
Most other indicators, including record high building approvals and forecast dwelling starts, point towards an industry which is now at or approaching its full capacity.
Typically skills and materials shortages at this stage in the construction cycle will lead to rapid inflation in the build cost of new dwellings, and there are already some indicators of this dynamic.
In particular, the Reserve Bank’s liaison work has noted a shortage of bricklayers and project managers in the residential space, despite the widespread availability of construction workers as the mining investment boom dies its long, slow death.
Construction loans
Unsurprisingly most buyers continue to seek finance to buy established property, although if you look closely, construction finance is rising steadily.

Drilling into this a little further, the rolling annual value of construction loans to owner occupiers appears to have peaked out at a record $22 billion.
However, rolling 12 monthly construction finance commitments to investors continue to rise, now up to $9.1 billion of loans written, which is also a record high.

Renovations

If there is one genuine bubble in the Australian economy, it is surely in the irrationally exuberant number of renovation TV shows advertised on the television (I’ve never actually watched one, I should disclose…not my thing).
Alas, outside Sydney, where renovations activity is both robust and rising, nobody seems to be undertaking any renovation projects themselves! 
Sure this was only the first month of the quarter, but the contribution to GDP growth from major alterations and additions in the second quarter of the year already looks likely like to be nil.

Meh.

The wrap

Some survey indices have lately pointed to a contraction in apartment and attached dwelling construction.
These indices are surely broken!
Just a few days wandering around the capital cities and major regional centres would tell you as much.
The residential construction boom continues, fuelled largely by sales to offshore buyers, and for this reason, the data on new dwelling commitments domestically doesn’t give us the full picture.
The construction loans data charted above – combined with record high building approvals and a strapping number of dwelling starts – imply that the next two years will see a sustained high level of activity in home building.
The all-important employment data is out later this morning.
After an ordinary flow of news in recent weeks, there will be more than a few twitchy observers today. 
A moderate result of +13,500 total employment is expected by market consensus for the month of May, with forecasts ranging from -5,000 to +20,000, although as we have seen from previous month’s figures, the survey can be hella volatile.

Westpac expects to see solid employment growth of around 1.75 per cent per year based on its Jobs Index, which has been steadily improving since November last year.

However, the seasonally adjusted unemployment rate is still considered likely to come in at 6.2 per cent or even higher.

A brief recap on the April Labour Force result can be found here – the Sydney economy looks relatively muscular, elsewhere not so much. 

Can I use Quickbooks to do this?

Q.)  Im working in a Multinational Pharmaceutical company that operate in the Gulf as in many other countries, and my Region role is to market the products we don’t keep inventory ,we don’t sell, we don’t collect payments, even we don’t prepare balance sheets.  We forward our expenses (allocated by account) to HQ’s and they do the rest.  Our expenses are as follows

1 payroll
2 office related  ( rent, courier,telephone,etc)
3 marketing related (meetings,gifts,,, etc)

My role is to prepare expenses formats, make payment to suppliers, control expenditures and prepare a lot of reports shows how much we spend and on which products are alike and prepare expense formats to be sent to HQ’s as well.

I dont have a tool to manage all of these , so i use excel which in fact very poor tool to manages all of these tasks. Can Quickbooks help me to prepare monthly statements per account to be sent to HQ’s and also help me to prepare internal reports that can help the team to wisly spend on marketing actvites and give me control over spendings against budgets?

A) Even though you don’t generate any financial statements you can use Quickbooks to create a budget for your spending, track how your spending compares with your budget, create spending reports by sales rep, location, etc.

Since you are paying vendors you can use Quickbooks to track what you expense and owe. In addition, it sounds like you have a checking account that Quickbooks can assist you in balancing.

I agree, Excel is probably a very time consuming way to track all of this. Even so, Quickbooks allows you to export just about every transaction and report into Excel so you can easily manipulate it, while having accurate numbers. Most of the reports can be modified extensively and run in many different ways to include a lot of different information.

I think with some time, and experimentation you would find it very useful.

Q)  Can I set up cost centers , like for Every Product a seprate cost center where i can charge them for any marketing actvities and generate the reports to show how much each product (cost center) is spending against budgets for its own?

In case this is possible, which edition of QB’s i should use, Non profit ,pro?

A) Use the “Class” feature in Quickbooks to create your Cost Centers. Quickbooks Pro should work for you. I don’t think the non-profit edition applies but you can use it and make changes to suit your reporting needs.

With the class feature you can create a separate budget and track all of your expenses. Each transaction you enter will give you a “class” column. Remember this one important thing…you have to enter the information correctly to get it reported back to your correctly. You can turn on a “reminder” in Quickbooks that will let you know if you forgot to enter the Class(Cost Center) in a transaction.

Response)  Thank you So Much You were Very hepful. I really appreciate it.
This material is for informational purposes only and not intended and financial, legal or tax advice. Please consult your finance, legal or tax professional to confirm the accuracy of all information. Quickbooks is a registered product of Intuit.
Email your question

Gold

Haven’t had much of a look at the gold price for a while.

So, here it is:

Financial Orbit wrap 15/06/15

Five sentences or graphics which sum up the Financial Orbit output over the last 24 hours across the website, twitter account and anything else thought about…

1. Far too much on Greece today…This IMF blog however has many of the answers/issues although more seem to be upcoming all of the time…

‘Proposed to lower the medium term primary budget surplus target from 4.5% of GDP to 3.5%, and give Greece two more years to achieve that target… the Greek government has to offer truly credible measures… Why insist on pensions? Pensions and wages account for about 75% of primary spending… We are open to alternative ways for designing both the VAT and the pension reforms… European creditors would have to agree to significant additional financing, and to debt relief sufficient to maintain debt sustainability’

2.  I was quite impressed that Metro AG of Germany managed to sell their department store divisional business for around x14 historic EV/ebit…but the market was more cautious about the use of funds, a majority of which it appears will be used to help expand/deepen the remain cash & carry plus supermarket businesses.

3. I spent part of this afternoon (UK time) listening to the Imperial Tobacco webinar on its recent US acquisitions which included the below graphic on US cigarette market share.  You can read my full report here.

4. Ugly industrial production data in the US versus the last few years:
Or to look at it another way…
5. A different mindset required for the next five years?  I think so…
(h/t @NickatFP)

Record 362,000 new motor sales in NSW

Robust new motor vehicle sales
The ABS released its Sale of New Motor Vehicles figures for the month of May 2015 today, which revealed a healthy enough 93,479 units shifted in the month.
On a rolling annual basis total new motor vehicle sales of 1.12 million sit a little below the record high of 1.15 million set in mid-2013.

More than 372,000 SUVs have been sold over the past year in Australia, and the Sports Utility could in time become the premier vehicle of choice for Australian consumers, surpassing the standard passenger vehicle.

The firing Sydney economy has helped New South Wales to a record high of 362,773 sales of new motor vehicles over the past 12 months.
However, the national figures are being pulled back by an ongoing decline in sales in Western Australia.

While the month-to-month numbers do jump around a little erratically as one might expect, smoothing the figures on a rolling annual basis shows that it has been the “wealth effect” of rising dwelling prices in Sydney and Melbourne which have driven new motor vehicle sales over the past year.

On the other hand, Western Australia is experiencing exactly the reverse dynamic as resources investment, and correspondingly employment, continues to decline.

Tax Tips for Self-employed Individuals

If you are in business for yourself, or carry on a trade or business as a sole proprietor or an independent contractor, you generally would consider yourself self-employed and you would file IRS Schedule C, Profit or Loss From Business or Schedule C-EZ, Net Profit From Business with your Form 1040.

Here are six things the IRS wants you to know about self-employment:

  1. Self-employment can include work in addition to your regular full-time business activities, such as part-time work you do at home or in addition to your regular job.
  2. If you are self-employed you generally have to pay Self-employment Tax. Self-employment tax is a social security and Medicare tax primarily for individuals who work for themselves. It is similar to the social security and Medicare taxes withheld from the pay of most wage earners. You figure SE tax yourself using a Form 1040 Schedule SE. Also, you can deduct half of your self-employment tax in figuring your adjusted gross income.
  3. If you are self-employed you generally have to make estimated tax payments. This applies even if you also have a full-time or part-time job and your employer withholds taxes from your wages. Estimated tax is the method used to pay tax on income that is not subject to withholding. If you don’t make quarterly payments you may be penalized for underpayment at the end of the tax year.
  4. You can deduct the costs of running your business. These costs are known as business expenses. These are costs you do not have to capitalize or include in the cost of goods sold but can deduct in the current year.
  5. To be deductible, a business expense must be both ordinary and necessary. An ordinary expense is one that is common and accepted in your field of business. A necessary expense is one that is helpful and appropriate for your business. An expense does not have to be indispensable to be considered necessary.
  6. For more information see IRS Publication 334, Tax Guide for Small Business, IRS Publication 535, Business Expenses and Publication 505, Tax Withholding and Estimated Tax, available at http://www.irs.gov or by calling the IRS forms and publications order line at 800-TAX-FORM (800-829-3676).

Links:

  • Publication 334, Tax Guide for Small Business (PDF)
  • Publication 535, Business Expenses (PDF)
  • Publication 505, Tax Withholding and Estimated Tax (PDF)
Back to Top