Forums
New posts
Forum list
Search forums
What's new
New posts
New resources
Latest activity
Trending Threads
Resources
Latest reviews
Search resources
FarmTV
Farm Compare
Search
Tokens/Searches
Calendar
Upcoming Events
Members
Registered members
Current visitors
New Resources
New posts
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Forum list
Search forums
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
Farm Business
Agricultural Matters
Xero - scanning invoices in.
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="bitwrx" data-source="post: 8036157" data-attributes="member: 86972"><p>Easy/hard, depending on what you want to do.</p><p></p><p>All the reports (standard and custom) can be exported as CSV, Excel or Google sheets - this is trivially easy. I find I can almost always get the info I want on a spreadsheet, then just manipulate it in excel to show you what you need (cost per tonne of pig feed over time for example.... <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite16" alt=":cry:" title="Crying :cry:" loading="lazy" data-shortname=":cry:" /><img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite16" alt=":cry:" title="Crying :cry:" loading="lazy" data-shortname=":cry:" /><img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite16" alt=":cry:" title="Crying :cry:" loading="lazy" data-shortname=":cry:" /><img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite16" alt=":cry:" title="Crying :cry:" loading="lazy" data-shortname=":cry:" /><img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite16" alt=":cry:" title="Crying :cry:" loading="lazy" data-shortname=":cry:" />). This does depend on good quality data though. I've taken care to set my <em>products and services</em> up properly, and diligently itemised every feed bill. It's great for one-off assessments of various things, like would I be better off buying my meds through a buying group or through the vet?. It does get a bit tedious exporting the same info every month to update your costings though.</p><p></p><p>If you're a bit more geeky like me, there are various products out there that plug in to Xero directly from excel. The cheapest I've found is called flex financial reporting. The data from any of xero's standard reports can be got into an excel table, and updated with a few clicks of the mouse. It's by no means lightning quick, but better than manual export of data.</p><p></p><p>The big plus is that you can have one spreadsheet that makes the same queries every time you update it. All the analysis is updated "just like that". If you're into power query and power pivot, it's great. I've got a great spreadsheet that gives me cost per meal-equivalent tonne of each ration for our pigs, or each enterprise, or each growth stage. No mean feat as we feed a mixture of bagged compound from one of two suppliers, bulk compound from one of two suppliers, straights bought ex store and delivered, and liquid by products of varying dry matters. It's really illuminating, and is only really feasible to update on a regular basis because of the data export functionality of Xero and the plugin. Wouldn't have even contemplated it with farmplan...</p></blockquote><p></p>
[QUOTE="bitwrx, post: 8036157, member: 86972"] Easy/hard, depending on what you want to do. All the reports (standard and custom) can be exported as CSV, Excel or Google sheets - this is trivially easy. I find I can almost always get the info I want on a spreadsheet, then just manipulate it in excel to show you what you need (cost per tonne of pig feed over time for example.... :cry::cry::cry::cry::cry:). This does depend on good quality data though. I've taken care to set my [I]products and services[/I] up properly, and diligently itemised every feed bill. It's great for one-off assessments of various things, like would I be better off buying my meds through a buying group or through the vet?. It does get a bit tedious exporting the same info every month to update your costings though. If you're a bit more geeky like me, there are various products out there that plug in to Xero directly from excel. The cheapest I've found is called flex financial reporting. The data from any of xero's standard reports can be got into an excel table, and updated with a few clicks of the mouse. It's by no means lightning quick, but better than manual export of data. The big plus is that you can have one spreadsheet that makes the same queries every time you update it. All the analysis is updated "just like that". If you're into power query and power pivot, it's great. I've got a great spreadsheet that gives me cost per meal-equivalent tonne of each ration for our pigs, or each enterprise, or each growth stage. No mean feat as we feed a mixture of bagged compound from one of two suppliers, bulk compound from one of two suppliers, straights bought ex store and delivered, and liquid by products of varying dry matters. It's really illuminating, and is only really feasible to update on a regular basis because of the data export functionality of Xero and the plugin. Wouldn't have even contemplated it with farmplan... [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Farm Business
Agricultural Matters
Xero - scanning invoices in.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.
Accept
Learn more…
Top