So in the previous post I mentioned that the accounting for Etsy was a little off and I couldn’t figure out why. Well today I started digging into the problem and figured out what was wrong. Each month I have to download 2 reports from Etsy.
EtsySoldOrder2021-X.csv and etsy_statement_2021_X.csv
Unfortunately, I’ve been downloading EtsySoldOrderItems2021-X.csv by mistake. Since the two reports have slightly different information some of the data wasn’t making it into the final report. I started downloading the wrong report at the first of the year and didn’t notice the wrong file name because I started a new folder for 2021.
I’ll need to go back and run the right reports, run them through the report tool, and fix the entries in Quickbooks.
Glad I actually noticed that there was a problem or I might have kept making the same mistake over and over.
So Etsy doesn’t offer the easiest to use reports. On the report it would appear that I sold $773.54 and had $243.79 in fees for a profit of $529.75. But sometimes the report doesn’t include all the fees you might incure.
Here is the information that is pulled out of the itemized reports that get entered into QuickBooks.
In this case the two match but unfortunately that’s not always the case. Notice the $73.35 for marketing fees? This is where Etsy charges 15% for advertising on orders that originated on places like Google. Etsy gets 5% of the sale so the advertising benefits them so why do merchants have to give them another 15%?
This year something changed in the reports and now the credit Shipping Income doesn’t calculate in the tool I use to summarize the itemized reports. Also this year, I haven’t been able to balance my Etsy Bank Account. The Etsy Bank Account is the monetization customers pay for product and shipping minus my fees and expenses on Etsy. The deposit the money into the checking account every Monday. So I treat the undeposited funds as a bank account and record the deposits into the checking account as transfers from one bank account to another.
I need to dig into the reports and figure out why the Etsy Bank Account won’t balance. I sent an email to the owner of the tool I use but didn’t get a response.
Notice Etsy shows $773.54 as my sales and the tool shows $803.10. Kind of a big difference.
Last month is the first month in 11 months that the company has had more income than expenses.
This is because traffic to the shop through Etsy has increased resulting in 9 online orders. Additionally, only 2 of the orders came from Etsy’s Offline Ads program which incures an additional 15% fee for advertising.
Monthly expenses have dropped off now that the workshop and rope machine are mostly setup. Still have things to do but most of the materials required have already been gathered.
Soon I’ll need to build a winding machine and yarn inspection table which will require some hardware, a motor, a foot control switch, and a speed control switch. Hopefully I can build it for less than $500.
Today I spooled some more yarn and ran it through the machine with a slight feed rate adjustment to the machine. People that buy Twisted Jute rope expect the rope to have a certain feel to it which is determined by the twist in the strands. The Twisted Jute 6mm rope has a rope lay of 21mm ±1.5mm.
As you can see in these photos the machine is properly calibrated…
The next step is to build a machine that will allow me to wind several spools at once while inspecting the yarn…
So the test yarn is spooled and loaded into the rope machine. Learned the basic operation of the counter module which shuts the machine off when it reaches a specified number of revolutions. Once the machine is ready for production I can calculate the volume of rope made per revolution. This is approximately 2 inches per revolution. So I can set the counter to stop once the machine has made the amount of rope I need.
I started swapping the belt pulleys and chain sprockets to produce rope that has the same twist and feel of the rope I make by hand.
I ran hundreds of feet of rope through the machine trying to get the pulley and sprocket ratios just right. I eventually ran out of yarn before I could get to where I wanted to be. The rope looks good despite not having been screened for contaminants before being twisted. The twist is also very close to the desired parameters.
Onice I get more yarn spooled and loaded into the machine I shouldbe able to get it dialed in pretty quickly. Lol, like maybe a day.
I believe I have enough yarn on hand to make 100m (12.5 hanks) of every color combination the shop offers.
The next big step is to design and build a machine that will wind several spools of yarn at once while the yarn can be inspected, repaired, and cleaned. Currently I inspect about 1800 feet in about 8 minutes or 225ft/min. I’d like to significantly increase that rate but definitely cannot fall below that rate. At the lowest speed the machine can turn yarn into rope about 2.5 times faster than I currently can inspect it. So even if I significantly improve the inspection and spooling rate the machine will almost always be waiting for more yarn.
So I’m finally able to print flanges effortlessly. With 2 printers working I can print up to 28 per day. I have enough flanges now to actually run the rope machine. Additionally, I have started having better success at making flanges with epoxy resin and with a few more molds I could be producing a batch of flanges equivalent to the number of molds each day. I’d kind of need about a dozen or more molds to really keep pace with the printers. I’d need to figure out where I can place 12+ molds that’s level and not in the way.
Now that I have more flanges than needed to run enough yarn to produce a rope I have to get the machine in order. I had placed a couple of work tables around the machine that would be in the way to run the machine. Of course those tables had quite a bit of stuff on them so I needed to get organized. First, take all those new flanges and cardboard tubes and make spools for the yarn. Next, thread the yarn through the machine.
I added a header to the back wall and hung the furniture dollies that are used to move the machine on the wall. I also added 3 shelves to hold the various tools and supplies I’m still using to get up and running.
Got things pretty well tidied up so all I need now is to run the machine and make adjustments until it makes rope according to my specifications.
So today I went to the workshop and uncovered the three new molds I poured yesterday. For the most part they turned out well. I cleaned and dried them then prepared to cast new flanges. Using rough math I was able to calculate the approximate volume of each flange to be cast as 1.65oz. I have four moths so that came out to 6.6oz of epoxy that needed to be mixed. I added black pigment to the resin and started to mix. Soon after starting to pour the mixed resin into the molds I realized that the table was not level and the resin was all flowing towards the low end. I finished the pour and repositioned the mold to be level. I used the heat gun to remove as many bubbles as possible.
So I had about 2oz of resin left which makes each flange about 1.2oz instead of 1.65. I’ll be able to mix a closer amount next time. It takes 24 hours for the resin to cure so that gives me time to print flanges on the 3D printer.
The original solid surface flange I used to make molds out of takes 3:56! That’s fine for casting but I need to speed up the print time so I can get to my goal faster. So I designed a flange that uses an open honeycomb grid on the flat side. It takes 2:45 to print. I redesigned it with larger hexagons and got the print time down to 2:00! With a little more tweaking I got the print time down to 1:43. So my Theoretical printed flange production rate is 13 per day. Of course sleep and work bring that number closer to 5/day. So 5 printed and 4 cast gets me 9 flanges a day so I could have my minimum required flanges in about 6 days.
Ever since I started considering using burlap bags as shipping material for rope I’ve wanted to get the company logo on the bag. Today I tried using the laser engraver for that purpose.
So the burlap is just a bit too loosely woven to get all the detail to show but you can definitely identify the logo. Unfortunately the logo isn’t very big and the process takes a long time so I may need to reevaluate that.
So it seems that most of the printer difficulties are resolved. Was able to print enough flanges and mold rings to end up with 4 molds.
That’s three poured today us the one that was just uncovered today.
With 4 molds I can pour 4 epoxy resin flanges per day. That’ll take 12 days just to get to the bare minimum to run the machine. Unfortunately, it’s has been taking nearly 4 hours to print a flange so not much more productive than casting resin. However, with a few tweaks to the flange design I can reduce the print time to about half. This makes it possible to print multiple flanges per day even if I have to work.
Between casting and printing I should be able to make enough flanges within a week.
Additionally I’ve printed a number of 3D printer upgrades which should help achieve more consistent and higher quality prints which may allow the print speed to be turned up a little.
So the yarn from the big 5kg spools has to be transferred to smaller spools to run through the rope machine. Mostly this is because the machine can handle 24 spools at a time but 6mm rope requires up to 54 spools. Besides the capacity issues of the machine, 24 full sized spools at 11lbs each is a lot to deal with. So smaller spools will need to be used with multiple threads per spool.
The problem is that the tubes don’t have flanges which limits how much yarn they can hold and creates a situation where the yarn can slip off the spool and get tangled on the spindle. So I need 2 flanges for every spool I use…
So I have a 3D printer that can print prototypes that I can then make molds from so I can cast flanges out of epoxy resin. Well that had a few hiccups. The printer had a few fails before it did a near flawless print of a flange and a frame for the mold…
The next print went more like this.
Then the extruder stopped working entirely. Had to replace the extruder motor and cable. Days wasted trying to fix, troubleshooting, and waiting for a replacement motor…
While waiting I went ahead and put together one form and filled it with silicone to make a reusable mold.
It was a little messier than expected and a lot wasted but overall my volume calculations were correct for the amount of mold maker to mix. Should find out today if I have a new reusable mold or a silicone paperweight.
So I wired up the Generator, Phase Converter, and the Rope Machine and turned everything on but nothing happened! The displays on the control panel came on but the machine didn’t do anything! Like OMG, what’s wrong. Did I wire something wrong? I mean I did move all of the electrical connections for the machine into an electrical box for safety and aesthetics but I took a lot of pictures before I started and the wiring didn’t seem that complex. I messed with the controls a bit but eventually had to call it a day. Nothing like walking away from such a big investment worried that it would never work. I sent a message to the manufacturer asking how to get the machine started but never got a reply. Not exactly great customer service! I mean I asked right after receiving the machine for some type of user guide…
Well, the next time I went to the workshop I inspected all of the wiring connections and the safety switches to see if there was a problem. By chance while trying to test the safety switches I opened and closed a gate and the machine finally came to life! I guess to get things going you have to reset the switches by opening a gate and closing it. I might wire in an interrupt switch to accomplish the same task eventually.
Shortly after I got the machine going the counter module started flickering then stopped working altogether. Well I contacted the manufacturer and they recommended that I open the module and inspect the soldering for the transformer. I did so and reported back that everything appeared to be okay. They then said we need to remove the transformer and test it. Umm, no! I’m not a technician and I’m not going to hire a technician to test a 50¢ transformer in a $25 module. I told them to send a new module! They did and I installed it today!
I also cleaned up the wiring with zip ties, cable wrap, and conduit clamps. All of the cables, cords, and wires are secured and neatly organized now.
All of the components of the machine are functioning now and all of the wiring is complete and well managed. There is an issue with the Phase Converter that is caused by the use of the Generator as the source for power but it is something that can be left as is for the time being.
Now, need to finish spooling a lot more test yarn onto cardboard tubes so I can start making adjustments to the machine so it will produce rope that is identical to what I currently make by hand…
