All Posts

Buchhaltungs tool vergleich für Freelancer

Buchhaltungs tool vergleich für Freelancer

Was benötigen Freelancer für eine konforme Buchhaltung Als freiberufler kann man von der einfachen Buchführung Gebrauch machen. Hierfür ist eine einfache Einnahmenüberschussrechnung notwendig wo sämtliche Geschäftsvorfälle chronologisch erfasst werden. Kriterien Elster anbindung: Freiberufler sind verpflichtet ihre Gewinne anhand einer EÜR in der Anlage EÜR in der Jahressteuererklärung zu erklären Umsatzsteuer-voranmeldung: Ist es möglich die Umsatzsteuer-voranmeldung direkt an das Finanzamt zu senden? EÜR: Kann die Anlage EÜR automatisch erstellt werden? Umsatzsteuererklärung: (wenn umsatzsteuer pflichtig) muss mit der jährlichen Steuererklärung eingereicht werden.

How to import influxdb data to Excel sheet with power query

How to import influxdb data to Excel sheet with power query

Recently a client needed some data from his influxdb linked to an Excel sheet. This can be achieved with a Power Query, from your Excel Workbook choose Data -> Get Data (Power Query) -> Blank query Replace the existing code with the following code: let url = "https://localhost:8086", orgName= "MyOrg", token = "MyOrganisation", query = Text.ToBinary(" from(bucket: ""climate"") |> range(start: -7d) |> filter(fn: (r) => r[""_measurement""] == ""climate"") |> filter(fn: (r) => r[""_field""] == ""humidity"" or r[""_field""] == ""temperature"") |> filter(fn: (r) => r[""deviceName""] =~ /U1/) |> pivot(rowKey: [""_time""], columnKey: [""_field""], valueColumn: ""_value"") |> keep(columns: [""_time"", ""deviceName"", ""humidity"", ""temperature""]) "), options = [ Headers = [ Authorization="Token " & token, accept="application/csv", #"content-type"="application/vnd.

Buchhaltung & Steuern als Freelancer selber machen mit Lexoffice & Smartsteuer

Buchhaltung & Steuern als Freelancer selber machen mit Lexoffice & Smartsteuer

Als Freelancer ist man verpflichtet eine rechtskonforme Finanzbuchhaltung zu führen. Es bestehen weitere Pflichten wie die EÜR in der Steuererklärung zu erklären und ggf. Pflichten für eine monatliche Umsatzsteuer-Voranmeldung (UStVA) Diese 3 Punkte kann man mit der Kombination lexoffice und Smartsteuer mit ein paar wenigen Clicks selber erledigen. Lexoffice hilft dabei die FiBu gesetzeskonform zu erledigen, zudem kann mit ein Paar Clicks die Umsatzsteuervoranmeldung direkt an das zuständige Finanzamt versendet werden.

Hiking Guide for Big Daddy (Dune 47)

Hiking Guide for Big Daddy (Dune 47)

Sossusvlei has become one of Namibia’s main tourist attractions. It is located in the South Western part of the Country and the closest “town” is Sesriem. I say “town” because this literally only consists of a petrol (gas) station. Sossusvlei is located in the Namib Desert, the oldest and driest desert in the world. It is located at the end of a river which is called the Tsauchab. The Tsauchab river flows from the Naukluft mountains and ends where the dunes start to become bigger and bigger. Here for many years water collected and formed several clay pans among which are Deadvlei and Sossusvlei.

Connect to your WiFi with a QR code

Connect to your WiFi with a QR code

It’s possible to generate a QR code that you can use to connect to the WiFi without having to manually enter the password. To do this you can use this open-source website, or preferably, you can use the qrencode cli tool. To install qrencode on MacOS you can use homebrew. brew install qrencode Then to generate the QR code qrencode -o wifi.png "WIFI:T:WPA;S:<SSID>;P:<PASSWORD>;;" Replace with your Network Name and with your password and you are good to go.

AWS Lambda Error: connect ENOENT /tmp/server-*.sock with nodejs lambda angular ssr

Background We have a SSR Angular application hosted on AWS. The Lambda function renders the requested page in front of an Api Gateway. We use serverless and an nodejs express server to render the requested page or resource. This error kept showing up when accessing our lambda serverless angular build from multiple regions simultaneously: { Error: connect ENOENT /tmp/server-q2r7kv33bik.sock at Object._errnoException (util.js:1022:11) at _exceptionWithHostPort (util.js:1044:20) at PipeConnectWrap.afterConnect [as oncomplete] (net.js:1198:14) code: 'ENOENT', errno: 'ENOENT', syscall: 'connect', address: '/tmp/server-q2r7kv33bik.

Easy setup of yootheme wordpress on aws lightsail

Easy setup of yootheme wordpress on aws lightsail

Lauch aws light sail instance connect via ssh sudo /opt/bitnami/apps/wordpress/bnconfig --disable_banner 1 && sudo /opt/bitnami/ctlscript.sh restart apache to enable https: sudo /opt/bitnami/bncert-tool and follow the prompts Install “YooTheme pro” theme Download the Wordpress theme from https://yootheme.com/pro Install and active the theme To add your API Key select “Customize” -> “Settings” -> “Api Key”: Enter your api key here, and publish the changes Add static pages with yootheme demo content Go to “Homepage Settings” -> Select “A static page” -> “Add New Page” -> name it “home” or what ever you like Go back, select “Builder” -> “Library” and select demo page you want to have, publish the changes and you can start customising the pages Repeat step 8 as many times as you require :)

How to lazy load 3rd party scripts globally in Angular using Typescript and webpack

We are busy migrating our web app from AngularJS 1.6 all the way up to Angular 7. For this we needed to migrate our ImageEditor module which allows users to customise images in the web app. For this module we relied on the TUI image editor plugin. Since this module is not needed on bootstrap we decided to lazy load it and wanted to have the vendors lazy load as well to optimise our apps startup time.

Angular and SEO for google search console

Angular and SEO for google search console

How to render Angular page for google search bot Recently I got the following preview for a website which was build using Angular 7. Google shows this as a preview: (blank screen for “This is how Googlebot saw the page:” and “This is how a visitor to your website would have seen the page:”) ![Google search console rendering preview](/uploads/Screenshot 2019-02-05 at 14.32.43.png “Google search console rendering preview”) This was not what I signed up for.

Lambda function to generate sitemap from mysql

This is a simple example of how you can use nodejs to generate a sitemap for your Angular application. Since Google can now index Angular application a sitemap helps the crawlers to find all your pages. I wanted to connect directly to our database to generate urls for dynamic pages. This was easily setup using our existing VPC and running the function inside of the VPC.